[SOLVED] Another way (mysql_num_rows())

[phat_hip_prog]

Hi,

I'm wanting to count the number of rows in a table but without having to execute a query first... i.e. to cut down on data transfered...

At the moment it's lucky that the table in question has an 'id' field which is small, but when there's thousands of entries, this will still be large.

 

 

Sorry this does it:

$s = "SELECT COUNT(*) as num FROM ".$tn."";