CodingForums.com - View Single Post

mharrison · 12-14-2012, 01:48 AM

So are you saying it should look something like this?

Code:

$result = mysql_query("SELECT * FROM patterns WHERE datetxt BETWEEN CURDATE() - INTERVAL 2 WEEK AND CURDATE() ORDER BY dsptxt");

When I use that for both 2 and 3 week, it displays the same as my new this week query does.

12-14-2012, 01:48 AM	PM User \| #7
mharrison New Coder Join Date: Dec 2012 Posts: 52 Thanks: 12 Thanked 0 Times in 0 Posts	So are you saying it should look something like this? Code: $result = mysql_query("SELECT * FROM patterns WHERE datetxt BETWEEN CURDATE() - INTERVAL 2 WEEK AND CURDATE() ORDER BY dsptxt"); When I use that for both 2 and 3 week, it displays the same as my new this week query does.