mysql php - select * where date = today?

[c0rrup]

Hello, I am trying to do a mysql query to get all the rows where date = "today".....

The problem is, I store my downloads date using:
$date = time();

is a mysql text field, which I'm guessing is really bad / slow?

Can anyone provide me with a better way to store dates and then also provide me with a mysql_query to select all that have been added today.


Thank you.

c0rrup Reviewed by c0rrup on 8th Feb 2011. mysql php - select * where date = today? Hello, I am trying to do a mysql query to get all the rows where date = "today"..... The problem is, I store my downloads date using: $date = time(); is a mysql text field, which I'm guessing is really bad / slow? Can anyone provide me with a better way to store dates and then also provide me with a mysql_query to select all that have been added today. Rating: 5