Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

Simple question. lets say I run the following:

$results = mysql_query("SELECT * FROM table");

How can I load the mysql results array into a PHP array without doing a while loop? Example:

$mysql_results = array();
$results = mysql_query("SELECT * FROM table");
$mysql_results = mysql_load_all_results_into_array($results);

Thanks!

share|improve this question
 
There is no such way...If it were You'd probably know of it... :-) –  shadyyx Nov 26 '12 at 16:38
add comment

4 Answers

up vote 1 down vote accepted

PHP's mysql_ library does not offer a method to "fetch all" rows without looping through the results-object using mysql_fetch_row() (or similar).

You can, however, update your code to use the mysqli library which contains a method named mysqli_result::fetch_all to perform the task you desire. Alternatively, you could update to use PDO which contains a similar method named PDOStatement::fetchAll.

As the mysql_ methods are being deprecated, updating to mysqli (or PDO) is the recommended way to go regardless.

share|improve this answer
add comment
up vote 0 down vote

You can't do that with mysql. You have to loop. You can do that with PDO

share|improve this answer
add comment
up vote 0 down vote

use:
$values = mysql_fetch_array($results);
but do check for success of your operation.... thus:
while ($values = mysql_fetch_array($result)) {
    $msg = "Array gotten successfully.";
 }

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.