mySQL Query based on time...(how?)

[agentsmith]

How do I write an SQL query which will return all rows from the table which are 72 hours or newer?

I have a drop down list that is populated from a database table.

At this time, ALL records are being pulled from the table.

The data that is contained is time sensitive, and only needs to be accessible for 72 hours or less.

I would like the drop down to only show records where the creation_date is 72 hours or less?

I have a column called "CREATION_DATE" which I pass a value to from the PHP page like this :

$creation_date = mktime();

then I INSERT it into the db.

any suggestions?

[RWJackson2006]

I would probably do it a different way.

I would somehow use date() to enter it into a table's column, and then just use an if statement to subtract from the current time. But, I could be wrong. That might take a little more work than is necessary too.