[COLOR=#000000][COLOR=#0000bb][/COLOR][FONT=Courier New][COLOR=#ff8000][COLOR=black]Can anyone tell me how I would[FONT=Verdana] setup a while loop to dump the $prices array into my select html tags?[/FONT][/COLOR][/COLOR][/FONT][/COLOR]
[COLOR=#000000][FONT=Courier New][COLOR=black][COLOR=#ff8000][/COLOR][/COLOR][/FONT][/COLOR]
[COLOR=#000000][FONT=Courier New][COLOR=black][COLOR=#ff8000]//create the Price Minimum menu
[/COLOR][COLOR=#0000bb]$MinPrice [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#dd0000]"<select name=MinPrice>
<option value="">Minimum</option>
"[/COLOR][/COLOR][/FONT][COLOR=#007700][COLOR=black][FONT=Courier New];[/FONT]
[/COLOR][/COLOR][/COLOR]
[COLOR=black]$MinPrice = 10;
$MaxPrice = 100000;
$q1 = “SELECT Price FROM re_listings WHERE Price BETWEEN ‘$MinPrice’ AND ‘$MaxPrice’”;
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) > 0) {
while($a1 = mysql_fetch_array($r1)) {
$prices[] .= $a1[‘Price’];
}
}
[/COLOR][FONT=Courier New][COLOR=black][COLOR=#0000bb]$MinPrice [/COLOR][COLOR=#007700].= [/COLOR][COLOR=#0000bb]$prices[/COLOR][COLOR=#007700].[/COLOR][COLOR=#dd0000]"</select>
“[/COLOR][/COLOR][/FONT][COLOR=#007700][FONT=Courier New][COLOR=black];[/COLOR][/FONT][/COLOR]
[COLOR=#007700][FONT=Courier New][COLOR=black]
[/COLOR][/FONT][/COLOR][FONT=Courier New][COLOR=black][COLOR=#ff8000]//create the max price menu
[/COLOR][COLOR=#0000bb]$MaxPrice [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#dd0000]”<select name=MaxPrice>
<option value="">Maximum</option>
“[/COLOR][/COLOR][/FONT][FONT=Courier New][COLOR=black][COLOR=#007700];
[/COLOR][COLOR=#0000bb]$MaxPrice [/COLOR][COLOR=#007700].= [/COLOR][COLOR=#0000bb]$prices[/COLOR][COLOR=#007700].[/COLOR][COLOR=#dd0000]”</select>
"[/COLOR][/COLOR][/FONT][COLOR=#007700][COLOR=black][FONT=Courier New]; [/FONT]
[/COLOR][/COLOR][COLOR=black]
Thanks!!![/COLOR]