Hvordan tæller man post?

<?php
$dato = date("H:i:s");

$connect2 =mysql_connect("localhost","navn","kode");
mysql_select_db("navn");

$result2 = mysql_query("select id from emails WHERE dato = '$dato'");
$number2 = mysql_num_rows($result2);
echo "<br>Idag har du: $number emails.";
}
?>

Eller :

select count(*) as antal from post where dato=CURDATE()