mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in error in php

Question

Possible Duplicate:
PHP Error: mysql_fetch_array() expects parameter 1 to be resource, boolean given

I am getting the following error for the code mentioned below in php:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Users/pubs/Sites3/parse/includes/parseAuthorSearch.php on line 62

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Users/pubs/Sites3/parse/includes/parseAuthorSearch.php on line 62

function findExactAuthorMatch($firstname, $lastname)
{
    $query22 = "SELECT COUNT(*) FROM authors WHERE lastname='".$lastname."' AND firstname='".$firstname."'";    
    $result22 = mysql_query($query22);
    $count22 = mysql_fetch_assoc($result22);
    if($count22 == 0) return false;
    else return true;
}

[I don't know why people still answer these questions](http://stackoverflow.com/search?q=%5Bphp%5D+Warning%3A+mysql_fetch_assoc%28%29+expects+parameter+1+to+be+resource%2C+boolean+given+in) — Mike B, Jul 10 '12 at 20:30

score 1 · Answer 1 · answered Jul 10 '12 at 20:26

1

Your query is wrong, try executing it in PHPMyAdmin or other, or try to echo it and see if it seems consistent.

answered Jul 10 '12 at 20:26

Jean-Marie Comets

716
2
7
21

score 1 · Answer 2 · answered Jul 10 '12 at 20:27

It looks like your mysql_query call returned false (a boolean), and then you're calling mysql_fetch_assoc on it without checking that it was valid.

Try this:

$result22 = mysql_query($query22) or die('Invalid MySQL query: ' . mysql_error());

That will tell you where the query died.

score 1 · Answer 3 · answered Jul 10 '12 at 20:31

You should not be using mysql_* functions any more
- See: http://us2.php.net/manual/en/mysqlinfo.api.choosing.php
You should never, ever, ever directly put variables into a query; see the various escape functions available for the corresponding API. In this case use mysql_real_escape_string
To see the error of your query, do:

if (!$result22) { die(mysql_error()); }

score 0 · Answer 4 · answered Jul 10 '12 at 20:28

This means your previous call to mysql_query() returned false, and so there are no results to fetch. This occurs when something was wrong with the query, such as a syntax error.

In this case you will want to check if $result22 is false, then see what mysql_error() has to say:

if ($result22 === false) {
    echo mysql_error();
    return false;
}

mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in error in php

4 Answers4