How to count table record

[devil_vin]

Hey.guys! I have a table here and would like to display all records.How could I count the number of record in table without manually specifying it in query statement.

 $result =mysql_query(sprintf('SELECT name,classification,screeningTime 
             FROM %s LIMIT 7', $tbl_name));

[devil_vin]

I tried the following script,it can't work

$tbl_name = "movie";
$query = mysql_query("SELECT * FROM $tbl_name");
$num_row = mysql_num_rows($query);
$result = mysql_query(sprintf('SELECT name,classification,screeningTime 
             FROM %s LIMIT $num_row', $tbl_name)) or die('Cannot execute query.');

[r937]

How could I count the number of record in table

select count(*) as number_of_rows_in_table from daTable

[devil_vin]

I can't perform query in the script,what went wrong on it?

$tbl_name = "movie";
$num_row = mysql_result(mysql_query("SELECT COUNT(DISTINCT name)FROM $tbl_name"),0);
$result = mysql_query(sprintf('SELECT name,classification,screeningTime FROM %s LIMIT "$num_row"', $tbl_name)) or die('Cannot execute query.');

[r937]

no idea

moving thread to php forum

[guido2004]

If you want to display all the records, there is no need to count them first and then use LIMIT.

Just select them all:

$result = mysql_query(sprintf('SELECT name,classification,screeningTime FROM %s', $tbl_name)) or die('Cannot execute query.');