Forum
Welcome, Guest
Please Login to access forum.
Re:SQL for adding fields to custom URLs (1 viewing) 
Go to bottom
TOPIC: Re:SQL for adding fields to custom URLs
#3321
John Dagelmore
Admin
Posts: 3873
User Online Now
Re:SQL for adding fields to custom URLs Karma: 84  
It seems that the error is a missing comma after the title at first line,
wrong:
SELECT CONCAT_WS(',', `#__ezrealty`.`smalldesc`, `#__ezrealty`.`locality`,`#__ezrealty`.`price`) AS title

correct:
SELECT CONCAT_WS(',', `#__ezrealty`.`smalldesc`, `#__ezrealty`.`locality`,`#__ezrealty`.`price`) AS title,
 
Logged Logged  
  The administrator has disabled public write access.
Go to top