how to prevent this error Warning mysql fetch assoc expects parameter 1 to be resource boolean given in on line 11

Question

Possible Duplicate    PHP Error  mysql fetch array   expects parameter 1 to be resource  boolean given       I m very confused with this error  it shows when I try to return a result from the DB that doesn t exist     I tried mysql num rows   but it returns the same error but instead of mysql fetch assoc expects      it says mysql num rows   expects      I set error reporting 0  to avoid showing this error  but I m not satisfied with this solution

User · Answer

The proper syntax is  in example     query   mysql query  SELECT   FROM beer ORDER BY quality    while  row   mysql fetch assoc  query    results      row

User · Answer

You don t need to prevent this error message  Error messages are your friends  Without error message you d never know what is happened  It s all right  Any working code supposed to throw out error messages    Though error messages needs proper handling  Usually you don t have to to take any special actions to avoid such an error messages  Just leave your code intact   But if you don t want this error message to be shown to the user  just turn it off  Not error message itself but daislaying it to the user    ini set  display errors  0   ini set  log errors  1     or even better at  htaccess php ini level And user will never see any error messages  While you will be able still see it in the error log  Please note that error reporting should be at max in both cases   To prevent this message you can check mysql query result and run fetch assoc only on success  But usually nobody uses it as it may require too many nested if s  But there can be solution too - exceptions        But it is still not necessary  You can leave your code as is  because it is supposed to work without errors when done       Using return is another method to avoid nested error messages  Here is a snippet from my database handling function      res   mysql query  query     if    res        trigger error  dbget    mysql error     in    query       return false        if   mysql num rows  res   return NULL       fetching goes here     if there was no errors only

User · Answer

You must check if result returned by mysql query is false    r   mysql qyery         if   r      mysql fetch assoc  r       You can use  mysql fetch assoc  r  to avoid error displaying

User · Answer

If you just want to suppress warnings from a function  you can add an   sign in front    lt  php  function that i dont want to see errors from parameters     gt

User · Answer

Here s the proper way to do things    lt  PHP  sql    some query       result   mysql query  q    if     result      throw new My Db Exception  Database error      mysql error        while  row   mysql fetch assoc  result        handle rows      Note the check on     result  -- if your  result is a boolean  it s certainly false  and it means there was a database error  meaning your query was probably bad

User · Answer

This is how you should be using mysql fetch assoc      result   mysql query  query    while   row   mysql fetch assoc  result            Do stuff with  row      result should be a resource  Even if the query returns no rows   result is still a resource  The only time  result is a boolean value  is if there was an error when querying the database  In which case  you should find out what that error is by using mysql error   and ensure that it can t happen  Then you don t have to hide from any errors   You should always cover the base that errors may happen by doing   if    result        die mysql error         At least then you ll be more likely to actually fix the error  rather than leave the users with a glaring ugly error in their face

[php] how to prevent this error : Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in ... on line 11

Examples related to php

Examples related to mysql

Examples related to warnings