another simple question.

[Trevor Kearsey]

select from db where id = 3...

if it doesn't exist, how can i display a message saying so.

for example:

"3" is not a valid selection.

make sense?
thanks.

[Shawn Wilson]

Trevor Kearsey wrote:

>
> select from db where id = 3...
>
> if it doesn't exist, how can i display a message saying so.
>
> for example:
>
> "3" is not a valid selection.

$res = mysql_query("select from db where id = 3");
if (!$res)
echo "ERROR" . mysql_error();
elseif (mysql_num_rows($res) == 0)
echo "No results from search";
else
echo "Results were returned from search.";

Shawn
--
Shawn Wilson
[email]shawn@glassgiant.com[/email]
[url]http://www.glassgiant.com[/url]