seer79
01-16-2003, 07:36 PM
I'm developing a site in PHP that uses a MySQL database. The Db has already been setup and filled with sample data for me. The main page I am working on requires data from three or four of the different tables.
Okay, I'm displaying race info and in order to show a driver's name I have query the driver table to find his name based on the driver_id.
I think I can simplify multiple queries here into one using the JOIN function, but I'm not real sure. Also, I don't know how to use the JOIN function.
If anyone could help me with this, it would be much appreciated.
Okay, I'm displaying race info and in order to show a driver's name I have query the driver table to find his name based on the driver_id.
I think I can simplify multiple queries here into one using the JOIN function, but I'm not real sure. Also, I don't know how to use the JOIN function.
If anyone could help me with this, it would be much appreciated.