<?php 
 
// connect to the database first
 
dbconnection();
 
// query
$result = mysql_query("SELECT * FROM tablename");
 
$rows = mysql_num_rows($result);
 
// results
echo $rows;
 
?>