sel * from * ... where date < 5 days old...?

[Anon]

First off, sorry for the redundancy of this post, I'm sure it's been asked dozens of times, but I couldn't find anything by searching because I didn't know what to search for. Anyway, I would like to know how you go about selecting records from a MySQL database where for instance, the date of the record is less than 5 days old, I can't seem to find anything reguarding this.

Thanks for any help..
Justin

[Anon]

Make sure you have a date or timestamp field in your records, then read the mysql manual.

[Anon]

hello,
plz. visit this site :www.evilwalrus.com for date functions scripts. u may get your solution over there.
-kapil

[Anon]

If you have this table:
CREATE TABLE entries (
col1 varchar(100) NOT NULL,
col2 varchar(80) NOT NULL,
col3 varchar(16) NOT NULL,
entry_time timestamp(14),
entID int(5) unsigned zerofill DEFAULT '00000' NOT NULL auto_increment,
PRIMARY KEY (entID),
KEY col2 (col2)
);

//And this variable:
$timeframe = 5;

//here is the select statement:
$result=mysql("$DBName","SELECT col1, col2, col3, entry_time, entID FROM entries WHERE TO_DAYS(NOW()) - TO_DAYS(entry_time) < $timeframe ORDER by entry_time DESC");

--ph

[Anon]

NT