New topics started today

[treszoks]

I cannot figure out a mysql query that will return the number of new topics started today. The today's active topics count is easy, but I want the count of the new ones created today.

[treszoks]

I had an epiphany. Here's the code:

$threads_today=mysql_query("SELECT distinct(threadid), count(*) as newcount FROM post GROUP BY threadid HAVING MIN(dateline)>=$datesql");
while($threads_today_stuff = mysql_fetch_array($threads_today)) {
$new_threads_today = $threads_today_stuff[newcount];
}