quicker dropdowns

[vavavince]

Heelooo!!!

i made 5 similar dropdown boxes and pulling the data from a MySQL table.. but it takes sooooo looong to display..

what i did was to pull the query (500 items long) to display drop down 1, and do the same query 4 more times to display the rest.. is there any other way for me to do this?

i did this --v

  

      <select name="id[]" size="1">
        <option value="" selected>Select Model</option>
        <?php 

$i=0;
while ($i < $num) 
	{
	$id=mysql_result($result,$i,"id");
	$make=ucfirst(mysql_result($result,$i,"make"));
	$model=mysql_result($result,$i,"model");
	echo '<option value="'.$id.'" ><strong><font size="3" face="Verdana, Arial, Helvetica, sans-serif">'.$make.'</font></strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;&nbsp;'.$model.'</font></option>';
	$i++;	
	}



?>
          </select>

5 times.. and it takes a good 45 secs to pull it all out.. anyone with an idea?

[drawmack]

You could use mysql_unbuffered_query and only execute the query once, then use mysql_fetch_object to get the data.

[vavavince]

ill try that..