Sort results from mysql query into 3 different select boxes

[jackiejackie]

Instead of having 3 queries to a mysql table to fill 3 different select boxes, I'm wondering if it would be better, time-wise, to have one query and sort the data into 3 different select boxes.

So, with the results from the query, test them such as "if certain_field="A" load into Select Box 1 else if certain_field = "B" load into Select Box 2 else load into Select Box 3"..

I'm thinking I might need to sort them into 3 different arrays first (?) ..... but do not know how to do this -

Thank you -

 

 

[MasterACE14]

do you have any code to show for this? You will probably need the 3 queries, however when you 'fetch' them they will be put into arrays, you don't need to put them into arrays again.

[jcbones]

while($row = mysql_fetch_assoc($result)) {
$storage[$row['certain_field']][] = $row['id'];
}
foreach($storage as $field => $arr) {
echo '<select name="' . $field . '">';
  foreach($arr as $id) {
   echo '<option>' . $id . '</option>';
  }
echo '</select>';
}

 

Something like that, you will have to play with it though.

[jackiejackie]

Thank you both -

I thought 3 queries would be a huge waste of time but running through the results and sorting into new arrays might be too - thank you