Results from SQL query

[NZ_Kiwi]

THis is my sql query which works fine..

<?php
$result = mysql_query ("select * from results_data where group_id = $latest_group_id and comp_run_id = $comp_run_id order by list_order");

while ($row = mysql_fetch_array($result))
{
?>

Now the tables has a id..... the id comes from another table... well should i say the id matches a id on another table.. what i want to do each time it loops is to get the id match it off the other table and display the details from this other table....

any ideas how to do this?

[w_geoghegan]

You can either use this:

WHERE thistable.id = thattable.id or you can use a JOIN. Not sure which one suits you.

Look up the JOIN function on mysql.org

Cheers.

William Geoghegan
GEOTEK Computer Services
- www.geotekcs.co.uk -

[NZ_Kiwi]

Originally posted by w.geoghegan
You can either use this:

WHERE thistable.id = thattable.id or you can use a JOIN. Not sure which one suits you.

Look up the JOIN function on mysql.org

Cheers.

William Geoghegan
GEOTEK Computer Services
- www.geotekcs.co.uk -

Okay would this work?

$result = mysql_query ("select * from results_data where  results_comp_run_team.team_id = results_team.team_id and group_id = $latest_group_id and comp_run_id = $comp_run_id order by list_order");