rasputinj Posted September 10, 2003 Share Posted September 10, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/1000-need-help-to-query-from-now-to-7-days-ago/ Share on other sites More sharing options...
Barand Posted September 10, 2003 Share Posted September 10, 2003 Time is reserved, but allowed as a fieldname. Use backticks ``. Try [php:1:26a151707a]<?php $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\"; ?>[/php:1:26a151707a] Quote Link to comment https://forums.phpfreaks.com/topic/1000-need-help-to-query-from-now-to-7-days-ago/#findComment-3396 Share on other sites More sharing options...
rasputinj Posted September 10, 2003 Author Share Posted September 10, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/1000-need-help-to-query-from-now-to-7-days-ago/#findComment-3397 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.