Displaying a message when search results are &quot

[Anon]

I'm using a MYSQL database and PHP to let people search for names in a database. When the search turns up no results that match, I get this error message: "Warning: Unable to jump to row 0 on MySQL result index 2".

What do I put on my PHP page to get a message to display instead of the error message?

[Anon]

Check the result object to see if there are any rows
before you try display them: mysql_num_rows().

[Anon]

I have this line on the page:
$numrow = mysql_numrows($result);

What else do I put in to redirect the page if the result is zero? (I don't know much PHP at all)

[Anon]

Well, are you using it like this:

&nbsp;if ($numrow < 1)
&nbsp;&nbsp;&nbsp;echo "No records found";
&nbsp;else
&nbsp;&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;// go ahead and display them...
&nbsp;&nbsp;&nbsp;}

[Anon]

Thanks.
I'll experiment with that a little.
I'm using a page that someone else built for me, so I don't know exactly what's being used for what.

[Anon]

Couldn't you just use:

if (!$numrow)
echo "No records found";
else
{
// go ahead and display them...
}

[Anon]

Sure, if you like mixing boolean and numeric significance
together in the same context. What's the benefit of that?