inner join query question
I've done inner joins before, and I figured this one would be doing the same thing as the others, but it isn't working, and I was wondering if someone could see the error?
I have 3 tables - a DJs table, a favs table, and a members table (favs table stores members favorite djs).
The favs table contains 3 columns - fav_id, member_id and the dj_id.
The DJs table contains 2 - dj_id, and name.
I'm trying to retrieve the name of each DJ that the member likes.
Thanks for taking a look.
Looks right to me. So maybe the problem is in your PHP code?
Start by debugging:
Oh, and if member_id is a NUMERIC field, then kill the apostrophes around $my_id.
Wanna know what I did? I forgot to encase the query in mysql_query() !!! I've done that a few times now, and have thoroughly learned my lesson!!!
|All times are GMT +1. The time now is 03:35 AM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.