Jump to content


This topic is now archived and is closed to further replies.


Need Help to query from now to 7 days ago

Recommended Posts

I am running phpnuke with mysql and I am try to modify a top 15 module that pulls the 15 most read stories. I would like to modify it to only show the most read stories in the last 7 days


Here is the current query



select sid, title, counter from ".$prefix."_stories  order by counter DESC limit 0,$top", $dbi);


the field Time is setup in this format 2003-09-02 11:40:46


I had tried to add this to the query before order by


Where time between now() and now() - interval 7 days


I do not get an error when I run, I just get no results. Is Time a reserved word? Do I need quotes around it, and can I use interval with now()?


I am a newbie when it comes to Mysql, I am trying to learn though. Any help would be appreciated.

Share this post

Link to post
Share on other sites

Time is reserved, but allowed as a fieldname. Use backticks ``.





$day_7 = date(\'Y-m-d\', strtotime(\'-7 days\'));


$query = \"select sid, title, counter from \".$prefix.\"_stories

where `time` > \'$day_7\'

order by counter DESC limit 0,$top\";


Share this post

Link to post
Share on other sites
:lol: Thank you very much for the code help. It works perfectly. I did not know you had to use the ` around the reserved words, someone told me I could use \' which did not work. Once again thanks alot, this was a good learning experience for me.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.