PHP/MySQL Query needed for UNIX Timestamp

[Limit]

Hi i need help with some code.

So far i have gotten my code to count how many records are approved and how many are not approved.

But i need help with making a query that counts the records posted today (on that day). I'm using UNIX timestamp (in PHP time()) to insert the date into a field called date.

Any ideas how i can pull the records posted on today.

[jg_v7n]

Work out the timestamp for 00:00:00 the previous night - midnight. Then work out the timestamp for 23:59:59 tonight. Then use BETWEEN to select all dates between those two timestamps.

$start_of_day = 193876543;
$end_of_day = 193891359;

$query = "SELECT * WHERE date_column BETWEEN ".$start_of_day." AND ".$end_of_day."";