Jump to Beginning of Records

[wilhud]

I'm trying to make multiple list boxes with the same records displayed in them. Is there a way that I can display the data and then jump back to the first record and display the exact same data I just ouptut?

Here's what I have now...

<select name="intTopResource1" id="intTopResource1">
<?php while ($Resource = mysql_fetch_array($rsResource)) { ?>
<option value="<?php echo $Resource["ResourceID"]; ?>"><?php echo $Resource["ResourceName"]; ?></option>
<?php } ?>
</select>

<select name="intTopResource2" id="intTopResource2">
<?php while ($Resource = mysql_fetch_array($rsResource)) { ?>
<option value="<?php echo $Resource["ResourceID"]; ?>"><?php echo $Resource["ResourceName"]; ?></option>
<?php } ?>
</select>

So the first time, the dropdown populates fine. Second time though, it's empty. Cuz I just don't know how to get it to go back to the first record so that I can start over. Any help is appreciated.

Do I have to have a separate mysql_query for each dropdown?

Thanks,
Wil

[ahundiak]

mysql_data_seek