Help Needed......

[NitroSimSev]

Well the results table is setup with race_name, name but no position with race name as primarary key. The qualifying table has race name and name.

question is how would the while and for loop look. I am bit new to PHP. I can set up the while loop it would be :

PHP Code:

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "ns_qualifying_results where race_name='$race' ORDER BY et, mph DESC LIMIT 16");  
    while ($rows = $db->fetch_array($query)) 
    {
    $name = $rows['name'];
             for ($rows = $db->fetch_array($query)) 
                  {
         This is where I am lost!!!!
                  }
    } 


Since race_name is in all tables I can make that primary