Reset a MySQL Recordset with PHP

When you run a recordset through a loop, you will not be able to re-run the recordset further down in the same page. Here is how to reset the recordset so you can use it again on the same page. Just place this code after your loop. Change the "$Recordset" to your recordset's variable.

<?php
  if (mysql_num_rows($Recordset) > 0)  {
    mysql_data_seek($Recordset, 0);
    $row_Recordset = mysql_fetch_assoc($Recordset);
  }
?>
If you have questions about anything on this site, you can find me on Google+: