Creat relationship

[scialom]

Hi,

Sorry for the simple question but I am new with php and mysql:

I have 2 tables using mysql

Tbl 1:

race_id - primery key
:
:

Tbl 2
Driver_id
race_id

how do I creat relationship between race_id in tbl2 to race_id in tbl 1?

Thanks,
Assaf

[michaelk]

you can learn all about JOIN 's here:

http://www.mysql.com/doc/en/JOIN.html

what you'll be doing is telling the SQL that you want information where the race_id will be the same in both tables. Joins can be a little tricky, and i've come up with some other ways around them (like creating a while loop with the first result, and placing the second set of SQL (from the other table) in the while loop). but it should work out fine, if you just look through the manual, and play arond.