Do you have a question? Post it now! No Registration Necessary. Now with pictures!
November 23, 2005, 12:03 am
rate this thread
MySql Database Table structure for phpnews_news is
id int unsigned auto_increment primary key,
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
SELECT * FROM PHPNEWS_NEWS where time between
DATE_SUB(CURDATE(),INTERVAL 30 DAY) and curdate()
Any help would be appreciated...
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum