$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!!!! } }
its
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)) { $n = $rows['name']; what ever else make sure you add it below $racering["$n"] = $rows; } for ($racers = $racering) { do the insert query here }