Jump to content


This topic is now archived and is closed to further replies.



Recommended Posts

I have edited an existing code to my own having LEFT JOIN feature in it. I am getting errors while replacing table name.



$tablepre = \"calendar\";

$sql = \"SELECT id, y, m, d, title, text, TIME_FORMAT(start_time, \'%l:%i %p\') AS stime, TIME_FORMAT(end_time, \'%l:%i %p\') AS etime, \" . $tablepre . \"users.uid, fname, lname FROM \" . $tablepre . \"mssgs LEFT JOIN \" . $tablepre . \"users ON (\" . $tablepre . \"mssgs.uid=\" . $tablepre . \"users.uid) WHERE id = \" . $id;


I need to replace [ \" . $tablepre . \"users.uid ] with [ clients.uid ]


Thankx in advance.

Share this post

Link to post
Share on other sites

It\'s alot easier to use aliases for table names when joining tables. That way you only have one occurence of each tablename


eg (partial query as sample)


SELECT a.id, a.y, a.m, a.d, a.title, b.name

FROM calendarmssgs a INNER JOIN calendarusers b

ON a.uid = b.uid

WHERE a.id = $id



Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.