king of newbie questions

[birdie]

hi, i am completely brain dead today so this should be a very easy question to answer.

Could someone please give me the method to finding out where a table has rows with a sql statement like this please..

$sql = "SELECT 2 FROM table WHERE 2=$var";

is mysql_num_rows the only way?
ps. there is a high chance that there will be no rows of this statement being returned so mysql_fetch_array etc usually bring up errors.


thanks

[trq]

Use [a href=\"http://php.net/mysql_num_rows\" target=\"_blank\"]mysql_num_rows[/a]().