Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean... error

Question

I always receive this error:

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

Here is my code:

$extra2 = mysql_fetch_array(mysql_query("SELECT desc from apps where id='$appid'"));

Please, [don't use `mysql_*` functions in new code](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php). *They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation)*. See the [red box](http://uk.php.net/manual/en/function.mysql-connect.php)? Learn about [prepared statements](http://en.wikipedia.org/wiki/Prepared_statement) instead, and use [PDO](http://us1.php.net/pdo) or [MySQLi](http://us1.php.net/mysqli). [This article](http://php.net/manual/en/mysqlinfo.api.choosing.php) will help you decide which. — Jay Blanchard, Oct 01 '14 at 17:42
[688 results](http://stackoverflow.com/search?q=Warning%3A+mysql_fetch_array%28%29+expects+parameter+1+to+be+resource) — Mike B, Oct 01 '14 at 17:42
Let's run through the list: code is using deprecated interface (check), code is subject to SQL Injection vulnerabilities (check), code is not checking return from query execution (check), column references in query are not qualified (check), no indication of any effort to research the error (check), no indication of any attempt to debug the problem (check), no actual question asked in the question (check). (Hmmm. Thanks for the status report?) — spencer7593, Oct 01 '14 at 17:54

score 3 · Accepted Answer · edited May 23 '17 at 11:49

3

desc is a MySQL reserved word

Either rename it to something else, or wrap it in backticks:

("SELECT `desc` from apps ...

Being:

As spencer7593 commented (thank you) and I quote:

I.e.:

("SELECT apps.desc FROM apps ...

edited May 23 '17 at 11:49

Community

answered Oct 01 '14 at 17:42

Funk Forty Niner

Thanks, I forgot about the ``, sorry. – Covrigelll Oct 01 '14 at 17:43
@Covrigelll You're welcome. – Funk Forty Niner Oct 01 '14 at 17:43
1

@Fred-ii-, **or**, qualify the column reference: **`SELECT apps.desc FROM apps`** – spencer7593 Oct 01 '14 at 17:58
@spencer7593 Good idea. I've made an edit to that effect, *thank you*. – Funk Forty Niner Oct 01 '14 at 18:00

1 Answers1