[RESOLVED] how to do: If not in table....

[Jfisher446]

I just dont know how to put this into code. I want to do:

$dupetablequery = "SELECT * FROM UsedInvTypes WHERE typeID = $typeID";
$duperesult = mysql_query($dupetablequery);
"if no records found..."

What is the statement for that? How does the result return if nothing was found???

Thanks

[redbullmarky]

checking [url=http://uk2.php.net/manual/en/function.mysql-num-rows.php]mysql_num_rows[/url] will tell you how many results are found

[code]
<?php
if (mysql_num_rows($duperesult) == 0)
{
  // no results
}
?>
[/code]

[Jfisher446]

Wonderful...thanks!