Return number of rows in table

[hunkychop]

does anybody know a mysql query that i can use in my php document that will return the number of rows their are in a table?

thanks, i cant find it in the MySQL mannual

[stymiee]

mysql_num_rows()

[hunkychop]

how whould i use that to return the result in php. do i just use

$result = mysql_num_rows(info);

or is there more to it

[stymiee]

<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows";

?>

[dc dalton]

Actually, not to step on Stymiee's feet but there is a a less memory intensive way to do it.

SELECT COUNT(*) FROM table_name

The result will be the num rows

[amit_kuetcse2k5]

Nice tutorial....Above two ways are helpful...................