How do you select records with a certain time range from MySQL using PHP?

Question

How to choose from MySQL, using PHP, records that were created for a certain period of time, if each record has creation time in timestamp?

Answer 1

You do a query similar to:

SELECT *
FROM table
WHERE creation_time BETWEEN '2011-01-01 00:00:00' AND '2011-03-01 00:00:00'

Here it'll select all entries that have a creation time between January 1st, 2011 and March 1st, 2011.