simple check of query

[prowley]

I am having problems with the following piece of code :-

//select records from database
$dbquery="SELECT * FROM table WHERE Name='$inputname'";
$dbrecords=@($dbquery);
if (!$dbrecords) {
echo("no records");
exit();
} else {
echo("records available");
}

I want to basically query the table and look for Name=$inputname. If it is in the table then carry on with the process otherwise let the user know that there are "no records".

Can anyone see where I am going wrong?

Cheers

Phil

[[deleted]]

mysql_query will return TRUE if the query succeded. This means that it can return NO rows, and return TRUE. A better thing would be to check the number of rows returned with mysql_num_rows and then decide what to do from that result...

[prowley]

thanks! makes sense now.