no. of rows in a table

[Anon]

i use MySQL in PHP. now all i want is to get the number of data (i.e the no. of rows) in a particular table and store it in a PHP variable. i want the SQL command!

[webphp]

Have you tried using
$sql = " select count(*) from myTable ";
?

[Anon]

gotcha! tnx Rick!