How to Get full recordset or result of a query

mohsini

Hi All

I have a query and It returns 10 rows, how can u get the whole recordset , all the rows in an array, at once. As much as i know in mysql there is mysq_fetch_array(),but that just returns one row and yu have to kep looping till the end.

like
$result=mysql_query("select * from names")
while($row=mysqlfetch_array($result)){
..
..

}

But i want to know is there any method in mysql to get the whole recordset, if not can anybody tell me any trick or way to get all the recordset in one array.

thanks anyhelp will be greatly appreciated.

laserlight

You would write:

$result = mysql_query("SELECT * FROM names");
$result_set = array();
while ($row = mysql_fetch_assoc($result)) {
    $result_set[] = $row;
}

mohsini

Hi there thanks for the reply.....

Yes, that works, but thats still like looping the whole recordset, i have queries which result in 800-900 rows.......so that means i have to loops each rows....isn't there any fastest method in mysql............in asp I have cool methods

laserlight

Yes, that works, but thats still like looping the whole recordset, i have queries which result in 800-900 rows.......so that means i have to loops each rows....isn't there any fastest method in mysql

I doubt that there will be much of a difference since either way you will have the entire result set in an array. Actually, stepping through the result set and working with the current row in the result set may be less resource intensive than dumping the whole result set into an array and then working on that array. Either way, you have to test if you want to know which is faster.

If you really want, use the PDO extension. That database interface has a fetchAll() method. But again, it may be no better than getting all the rows yourself, and may be worse than stepping through the result set one by one.

mohsini

Hi laserlight

i keep getting this error.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in

can u plz help me on this......i have also added u on msn, i thoguht i can ask u get some help on msn as that would be quick...plz help

regards

NogDog

99% of the time that error indicates that your query was not able to be processed by the DBMS. (The other 1% or so of the time it indicates a simple typo, such as using the wrong variable name for the result.) Check the result of you PHP mysql_query(), and if it's false output some debug info such as mysql_error() and echoing the actual query used.

mohsini

Hello, thankx for replying, yes i think i got to know the problem but i dont know how to solve. The problem is im using a stored procedure and the query is SELECT. And after ready mysql manual it says that you cannot use select query in stored procedure or function.

So, is there any ways or am i wrong. I think there should be a way to pass the recordset from stored procedure.