Jump to content

Linking tables


Suchy

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/49561-linking-tables/
Share on other sites

Archived

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

×
×
  • Create New...

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.