selecht with no rows problem

[KryptoS]

Hello ,

$result = mysql_query("select * from tblTest"

how can I check if there are records in the tabel or not?
I thought of: mysql_num_rows($result) > 0 but it doesn't work? The One And Only KryptoS

 

[sleipnir214]

mysql_num_rows() will return the number of rows returned by a query. If you are performing "SELECT * from table", which will select all rows, mysql_num_rows() will return the number of rows in the table.

You say it doesn't work. What is mysql_num_rows() returning for that query?


Another way to get the number of rows in a table is to perform "SELECT count(*) from table", which will return the number of rows in a table. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!