Warning mysql fetch array expects parameter 1 to be resource boolean given in

Question

Possible Duplicate    PHP  Warning  sort   expects parameter 1 to be array  resource given        Please help   I get following Error   Warning  mysql fetch array   expects parameter 1 to be resource  boolean given in        Here is my Query    query    SELECT ListNumber FROM residential     result1   mysql query  query        if  mysql num rows  result1   gt 10             difference   mysql num rows  result1  - 10            myQuery    SELECT   FROM  residential  ORDER BY  id  LIMIT 10     difference            result2   mysql query  myQuery    echo  result2           replace    str replace              result2       while   line   mysql fetch array  result2  MYSQL BOTH

User · Answer

result2 is resource link not a string to echo it or to replace some of its parts with str replace     http   php net manual en function mysql-query php

User · Answer

mysql fetch array   expects parameter 1 to be resource boolean given in php error on server if you get this error    please select all privileges on your server  u will get the answer

User · Answer

The code you have posted doesn t include a call to mysql fetch array    However  what is most likely going wrong is that you are issuing a query that returns an error message  in which case the return value from the query function is false  and attempting to call mysql fetch array   on it doesn t work  because boolean false is not a mysql result object

User · Answer

Your query   myQuery  is failing and therefore not producing a query resource  but instead producing FALSE   To reveal what your dynamically generated query looks like and reveal the errors  try this    result2   mysql query  myQuery  or die  myQuery   lt br  gt  lt br  gt   mysql error       The error message will guide you to the solution  which from your comment below is related to using ORDER BY on a field that doesn t exist in the table you re SELECTing from

User · Answer

This error comes when there is error in your query syntax check field names table name  mean check your query syntax

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

Examples related to php

Examples related to mysql