[NitroSimSev]

I am currently developing an elimination bracket mod. I am a noob when it comes to to php and I need some help with a portion of the code.
So here is the scenario:

1. I have a table that holds all the qualifying information.
2. I then retrieve the qualifying information from the DB to give me 16 results in ascending order for the 16 car elimination bracket.
(The results being selected are name, et, mph)
3. Then 16 results would be used to create the pairing information that would be put into another table called elimination_round1.

How would the php code look to pull the information out of the sort so I can fill in the ladder. IE record 1 would be matched up against record 16, record 2 would be matched up versus record 15, etc. Any ides?

would something like this work?

PHP Code:

<?php
 
$result_qual = $vbulletin->db->query("SELECT name, et, mph FROM " . TABLE_PREFIX . " qual_results ORDER BY ASC LIMIT 16"); 
        list($name0, $et0, $mph0) = mysql_fetch_array($result_qual);         
        list($name1, $et1, $mph1) = mysql_fetch_array($result_qual);         
        list($name2, $et2, $mph2) = mysql_fetch_array($result_qual);         
        etc.
 
{       
eval('$resultsqual .= "' . fetch_template('ladderbits') . '";');
}
 $vbulletin->db->free_result($resultqual);
?>