print # of rows returned by query?

[Fife_Club]

1. How do you print the total number of results that a particular query returned? (For why I am asking see this thread )

2. How do you print out the total number of all entries/records/rows in a mySQL database (how big the database is)?

[greg252]

mysql, i assume?
use mysql_num_rows

[John_Canyon]

$select = mysql_query("SELECT * FROM yourtable");
$totalEntries = mysql_num_rows($select);