Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given ERROR

Question

I'm trying to retrieve information from a MYSQL DB. However, I get this error.

My code:

$result = mysql_query("SELECT * FROM DB ORDER BY name ASC");
while($row = mysql_fetch_array($result)) {
   echo  ucwords($row['name']) . "\t" . ucwords($row['number']) . "<br>"; 
   echo "<hr width='20%'>";
}

Your query saved in `$result` fails. Did you research this at all? — kero, Dec 23 '13 at 21:26
See [this answer](http://stackoverflow.com/a/11674313/250259) for how to troubleshoot this. — John Conde, Dec 23 '13 at 21:26
Your query failed. `$result` is not a `mysql_result` resource. You must check for query execution success before fetching. — Michael Berkowski, Dec 23 '13 at 21:27
your mysql_query is failed to execute right query. Show me full code. I will find out. — Arshad Hussain, Dec 23 '13 at 21:29
This is what you saw when you posted this question http://i.imgur.com/ImzI7yH.png. Very very sad... — Mike B, Dec 23 '13 at 21:33

score 1 · Answer 1 · answered Dec 23 '13 at 21:27

1

You have an error in your query. So mysql_query is not giving you a resultset. Instead you get the value false, thus a boolean.

answered Dec 23 '13 at 21:27

N0lf

148
7

score 0 · Answer 2 · answered Dec 23 '13 at 21:34

Use http://www.php.net/manual/en/book.pdo.php instead of mysql function!

Example #1 Demonstrate PDO::query

<?php
function getFruit($conn) {
    $sql = 'SELECT name, color, calories FROM fruit ORDER BY name';
    foreach ($conn->query($sql) as $row) {
        print $row['name'] . "\t";
        print $row['color'] . "\t";
        print $row['calories'] . "\n";
    }
}
?>

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given ERROR

2 Answers2