View Full Version : php - Mysql Quering two tables

07-17-2012, 08:02 PM
Hello Guys..

I have two mysql tables one called "ads" and the other called "ads_photo" and what they have in common is the ad_id.

I need to be able to query both tables (maybe a left join?) and grab the top 8 - 10 profile_photos out based on the date.

The columns
Table - ads

ad_id, ad_date
Table - ads_photo


Just need some help..Thanks!

07-17-2012, 09:11 PM
Did you supply all columns of both tables? There should be some kind of Primary/Foreign key relation tying the photos to the ad_id.

And, yes, a JOIN query would be perfect for this.

BTW.. this is really more of a SQL question than a PHP question. Just sayin'. :)

07-17-2012, 09:17 PM
Thanks for the comment wolf.. The primary key is the ad_id

The reason I posted this in PHP is because I will have to do some type of loop..

07-17-2012, 09:19 PM
Ah, understood. If the PK is ads.ad_id, what is the FK in ads_photo?

07-17-2012, 09:24 PM
Thats correct...

07-17-2012, 09:56 PM
What is correct?

07-17-2012, 10:07 PM
Oh Sorry I'm not sure what the foreign Key would be...

07-17-2012, 10:28 PM
You can't tie a photo in the photo_ads table to an ad in the ads table unless you have something to associate the two. You need a FK in the ads table that is the ad_id associated with the photo.

Anyway, if you do put an FK in the photo_ads table that ties to the ad_id, the query would be something like:

SELECT a.*, b.*
FROM ads a JOIN photo_ads b on b.ad_id = a.ad_id
ORDER BY ad_id

... or something similar.