|
|
Posted by lane.dj on 11/23/05 02:15
I'am having a problem with an SQL statement...
MySql Database Table structure for phpnews_news is
id int unsigned auto_increment primary key,
posterid int,
postername char(40),
time int,
etc ......
The Time column is populated using a php time() function.
How do I use the TIME column to give me only the last 7 days worth of
data. Not sure how to manipulate unixtime formats... any help would be
appreciated..
SELECT * FROM PHPNEWS_NEWS where time between
DATE_SUB(CURDATE(),INTERVAL 30 DAY) and curdate()
Any help would be appreciated...
Dan
Navigation:
[Reply to this message]
|