ASP(VBScript), from time to time, has some neat features. One is a function
called GetRows, which pertains to the Recordset object. Its purpose is to pull the entire recordset into a 2d array and close the connection to free resources. This type of functionality can be quite useful in a high load environment. So I thought it would duplicate the functionality with PHP. So here it is...
function GetRows($handle)
{
/*
This function emulates the ASP GetRows function. It creates a 2 dimensional
array of the data set where the :
1st dimension is the row number of the data
2nd dimension are the data fields
Returns a two dimensional array if there are record or false if no records
come out of the query
*/
if (mysql_num_rows($handle)>0){
//initialize the array
$RsArray1 = array();
//loop thru the recordset
while ($rows = mysql_fetch_array($handle))
{
$RsArray1[] = $rows;
} //wend
return $RsArray1;
}else{
//no records in recordset so return false
return false;
} //end if
//close the connection
mysql_close($handle);
} //end function
?>