$db = //db connection $sql = mysql_query("SELECT * FROM table", $db); $rows = mysql_num_rows($sql); //echo $rows;