Num Rows

[Krakken]

Hi,

Is there a way to see if any values were returned from a SELECT statement without giving an error?

Thanks, Krakken.

[rIkLuNd]

I'm not sure, but I think you could do like this:

<?php

# connection stuff here...

$query = "SELECT * FROM table";
$result = mysql_query($query);

$rows = mysql_num_rows($result);

if($rows > 0)
{
echo "Result found";
}
else
{
echo "Nothing found...";
}

?>

[Krakken]

i do but it returns a warning when i have no values

[rIkLuNd]

then I think that the only solution is to use [man]mysql_error[/man]... :p

[Krakken]

Bleh nevermind. Thanks.