[SOLVED] Simple question based on the number of rows.

[djpic]

All I want to do is get the total number of rows in a table.  I know I can use mysql_rum_rows() but that deals with a query and I don't need a query.  I just want to know how many rows there are using less resources than it having to count all the rows in SELECT statement.  I heard somewhere that is was possible to pull it from a particular place that will not run a full query on a table in a database.

[Barand]

SELECT COUNT(*) FROM tablename

[djpic]

that doesn't work.  It just returns a value of: Resource id #3

[Barand]

OK, spoonfed solution

 

$res = mysql_query("SELECT COUNT(*) FROM tablename");
$num_rows = mysql_result ($res, 0);