Jeffro Posted March 18, 2011 Share Posted March 18, 2011 I continue to learn php... and still without the ability to create joins in mysql. Not a great mix... but, I need some quick help. Can someone join this for me? I need the select statement for my php code. select id, title, categoryid from images select id, category from categories images.categoryid = categories.id I'm trying to construct a url. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/230984-help-with-a-simple-join/ Share on other sites More sharing options...
TheUkSniper Posted March 18, 2011 Share Posted March 18, 2011 SELECT {Whatever Variables You Want Here} FROM `images` LEFT JOIN `categories` ON `images`.`categoryid` = `categories`.`id` Quote Link to comment https://forums.phpfreaks.com/topic/230984-help-with-a-simple-join/#findComment-1189055 Share on other sites More sharing options...
Jeffro Posted March 18, 2011 Author Share Posted March 18, 2011 Thanks much! I'll give it a whirl. Quote Link to comment https://forums.phpfreaks.com/topic/230984-help-with-a-simple-join/#findComment-1189133 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.