How do I loop whole rows for every INT?

[wxdqz]

Im fairly new to php and *attempting to* making a master page for a gaming club roster, but I need to loop $field[1] through every $field[0] INT number.



$sql = "select * from rank_select";
$result = mysql_query($sql, $link);

do{//////I cannot get $ranks[1] to loop ENTIRELY THROUGH for EVERY INT number in $ranks[0]////////////

echo "BT$ranks[0] Rank: <BR>\n";
echo "<SELECT NAME=\"bt $ranks[0] rank\">\n";

echo "<OPTION VALUE=http://www.phpbuilder.com/board/archive/index.php/\"$ranks[1]\">$ranks[1]";

}while($ranks = mysql_fetch_array($result));