print out "no matches found"

[Anon]

Hello!

How do I writa so, if there is no matches found in a SQL question, that is printed, I have tried this, bit it's not working.

Thanks in advance.

Klas

$sql = "select * from table";
$result=mysql_query($sql) or die("Could not find any matches");

[van__]

Klas wrote:

$sql = "select * from table";

$result=mysql_query($sql) or die("Could not find any matches");

Well, mysql_query doesn't work that way.
Die will only come into play if there is an error in your query.

Try...

$sql = "select * from table";
$result = @($sql);

if (mysql_num_rows($result)<1) {
echo "No results found";
} else {

//loop your output...

}

[Anon]

Thanks :-)

Klas