Posted by Chuck Anderson on 09/26/06 02:18

monomaniac21 wrote:
> Hi all!
>
> How can you get rid of the error that displays if you do a query which
> returns no result and then try and fetch the array, WITHOUT having to
> put the while in another conditional like if ($result != ''), something
> more efficient if possible.
>
> regards
>
> Marc
>
>
You can always append the mysql_query with @, but then you're only
hiding a real problem.

Query's that return no results are not erroneous, they do not display an
error message. If you get an error message it means your query was
invalid. echo mysql_error() to find out why.

--
*****************************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
*****************************

• Next in forum: Any idea what's wrong with this code snippet?
• Prev in forum: Hylafax and PDF
• Thread view: Re: while ($row = mysql_fetch_array($result)) error suppression

[Reply to this message]