J!Extensions Store™
Forum
Welcome, Guest
Please Login to access forum.
- Joomla! Extensions Store
Re:SQL for adding fields to custom URLs (1 viewing) 
Go to bottom
TOPIC: Re:SQL for adding fields to custom URLs
#3319
John Dagelmore
Admin
Posts: 3873
User Online Now
Re:SQL for adding fields to custom URLs Karma: 84  
Well you should replace only the title line with the concat but leave untouched all the other fields, this is a correct query:

SELECT CONCAT_WS(',', `#__ezrealty`.`smalldesc`, `#__ezrealty`.`locality`,`#__ezrealty`.`price`) AS title,
`#__ezrealty`.`id`,
`#__ezrealty`.`cid`
FROM `#__ezrealty`
WHERE
`#__ezrealty`.`published` = '1'
AND (`#__ezrealty`.`language` = '*' OR `#__ezrealty`.`language` = {langtag})
ORDER BY
title ASC
 
Logged Logged  
  The administrator has disabled public write access.
Go to top