Simple Question about Rows

[JSHINER]

How can I display the number of rows in a table?

 

There are ___ rows in this table.

[skali]

$query = 'select count(*) from your_table';

$rs = mysql_query($query);

if($rs)

  echo mysql_result($rs,0,0);

[chronister]

Or you could use

 

<?php

 

$query="SELECT * FROM table_name";

$result=mysql_query($query);

$num=mysql_num_rows($result);

?>

 

There are <?=$num ?> rows in this table.