mysql php - select * where date = today?

[immortalxx]

if u dont understand time() or mktime(), just store ur dates using date field. google mysql date

if ur storing using time(), change ur field type to INT, since its faster then using VARCHAR or CHAR or similar.

immortalxx Reviewed by immortalxx on 9th 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