multiple mysql_fetch_array() calls

[themule]

Hello.. I'm trying to populate multiple select boxes with the same query, but only the first iteration works.

<select>
while($row = mysql_fetch_array($myQry)){
  <option>echo $row['name']
}
</select>
**Populates correctly
<select>
while($row = mysql_fetch_array($myQry)){
  <option>echo $row['name']
}
</select>
**No data

Any thoughts?

[sasa]

use mysql_data_seek($myQry,0); before while loop

[markt]

Or how about unsetting $myQry?
Or mysql_close() ....

[themule]

mysql_data_seek worked.. thanks sasa!

[akitchin]

i'm going to suggest that you be nicer to your database, and stop making it work so hard.  plug everything from your returned rows into an array and loop through that rather than forcing the database to go through the same set of results over and over:

[code]<?php
while($row = mysql_fetch_array($myQry))
{
  $options[] = $row['name'];
}

echo '<select name="something">';
foreach ($options AS $name)
  echo "<option>$name</option>";
echo '</select>';
?>[/code]

everytime you want to loop through your results, use the foreach() loop on the local $options variable rather than the while() MySQL loop.