Suchy Posted May 1, 2007 Share Posted May 1, 2007 I have a page that takes a link from MySQL to display a photo, now I want to have user comments for that specific photo. I have 2 tables, which have these fields: photo comment -photo_id -comment_id -url -photo_id -name -comment How to link these two tables, so that when someone comments on a specific photo (ex. photo 4) a new entry will be added to the comment table (name , comment) and in the photo_id field will be the id of that specific photo (ex. photo 4). So that on that very same page where that specific photo is only the comments for it will be displayed. Quote Link to comment Share on other sites More sharing options...
MadTechie Posted May 1, 2007 Share Posted May 1, 2007 just make sure the photo_id in comments is the same as the one in photo, !! i am assuming you havn't worked with databases before, i suggest you do some research! Quote Link to comment Share on other sites More sharing options...
joshi_v Posted May 3, 2007 Share Posted May 3, 2007 select comm.comments from comments as comm LEFT JOIN photos as ph where ph.photo_id= comm.photo_id. Is this what ur trying to get? Quote Link to comment 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.