Hello everyone,
I’m stumped, I’m working on a custom Joomla extension, its saving a set of foreign keys into my table’s column like this [“1″,”2″,”3”] they are wrapped with the brackets, how do I do a join to look up their titles by ID when they are saved like that, currently I don’t think mysql sees that column’s content as IDs because of the brackets?
Here is my query:
‘SELECT p.*, c.title AS category FROM xszfo_products_pianos AS p’
INNER JOIN xszfo_categories AS c ON (p.catid = c.id)
INNER JOIN xszfo_products_finishes AS f ON (p.finish = f.id)
WHERE p.id = ‘1’
Please, if you could point me the right direction I would be so grateful!
