$count_query = "SELECT COUNT(*) as tall FROM $database"; $row2 = mysql_query($count_query) or die(mysql_error()); $count = $row2['tall']; echo $count;