php mysql_fetch_array query help

BlueDamon

New Member
Hi i'm trying to process the mysql_fetch_array query below and simplify the code so only 1 query is ran for both sets, is that possible \[code\]<select name=[set1]> <?php$set1 = mysql_fetch_array(mysql_query("SELECT `Locale` FROM `language` WHERE `Setting` = '1' ORDER BY FormatSet"));while($row = $set1){ echo "<option value=http://stackoverflow.com/"$set1\">$set1</option>\n";}?> </select> <select name=[set2]> <?php$set2 = mysql_fetch_array(mysql_query("SELECT `Locale` FROM `language` WHERE `Setting` = '2' ORDER BY FormatSet"));while($row = $set2){ echo "<option value=http://stackoverflow.com/"$set2\">$set2</option>\n";}?></select>\[/code\]
 
Top