How do I turn a resource into an array?

[narutodude000]

I want to transform the output of mysql_query("SELECT...) into an array. How can that be done?

[NogDog]

You have to use one of the mysql_fetch_*() functions in a loop.

$result = mysql_query($sql);
$data = array();
while($row = mysql_fetch_assoc($result))
{
   $data[] = $row;
}
// view array:
echo "<pre>".print_r($data, true)."</pre>"; 

[narutodude000]

I got

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

[dk_zero-cool]

You might want to make sure that your query does not return false.

if(($result = mysql_query($sql)) !== false) {
    while($row = mysql_fetch_assoc($result)) {
       $data[] = $row;
    } 

}else {
    echo mysql_error()
} 

[NogDog]

That means your query was rejected by MySQL for some reason, and thus returned boolean false instead of a query result resource. Add an if() condition to see if $result (or whatever variable you used for the mysql_query() return value) is false, and if so log or display the value of mysql_error() to find out what it didn't like. You might also want to include the query string in that debug info.

$result = mysql_query($sql);
if($result == false)
{
   user_error(mysql_error()."<br />\n$sql");
   echo "<p class='error'>Oops! Database error.</p>";
}
else
{
   // do your fetch and other processing with the query result....
} 

[narutodude000]

I finally found the error, I added a "s" after $result for one of them. Carelessness