php mysql easy peasy

[mattux]

hi there

i need to reuse a sql query a few times on one page but i think after the first time i need to set the query to the first record again but am unsure of how to do it, here is my code.

	while ( $a_row = mysql_fetch_array( $result ) )
	{
	?>
	 <tr>
	  <td>
	  <select name=seasons>
			<?php
			while ( $b_row = mysql_fetch_array( $result_seasons ) )
			{
			echo ("<option value='".$b_row['season']."'>".$b_row['season']);
			}
			?>
	  </select>

i need something like a movefirst() function, or making it a multidimensional array maybe.
what is the best way to acheive this please

cheers

 

[mattux]

hi ladforce

i didnt explain myself properly but, thats exactly what i wanted, thanks very much.

matt