[eluser]CroNiX[/eluser]
Not if it's working...
Here is a similar select I have to show...
Code:
$db->select("CONCAT('http://listings.', user_agent_profile.website_url, 'somedomain.com/i/', user_agent_profile.website_idx_cid, '/') as idx_url", FALSE)
Notice how much cleaner it is (it's also all wrapped in double quotes while quoted text within the query is using single quotes - such as in the CONCAT. You're using single quotes for everything which makes you have to escape them first for the ones that are actually supposed to be quotes in your query)