Recordset
Posted: Mon Feb 16, 2009 2:07 am
hello guys, i have a confusion that, can we use a recordset more than one time or not???
suppose i have following recordset..
Now suppose i have fetch it as follows...
now i want to know tht, can i again use it as above......
thanks Dheeraj.
suppose i have following recordset..
Code: Select all
<?php
mysql_select_db($database_login, $login);
$query_Recordset1 = "SELECT * FROM promotion";
$Recordset1 = mysql_query($query_Recordset1, $login) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
Code: Select all
<?php do
{
...............
...............
...............
}while($row_Recordset1 = mysql_fetch_assoc($Reordset1));
?>
thanks Dheeraj.