Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
irealms
Forum Contributor
Posts: 215 Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds
Post
by irealms » Fri Oct 15, 2004 3:42 am
i'm having problems getting this to work
SELECT * FROM orders WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= dateadded AND status!='Quote'
keep getting errors and despite trying the manual i can't seem to get it working. Any ideas?
twigletmac
Her Royal Site Adminness
Posts: 5371 Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK
Post
by twigletmac » Fri Oct 15, 2004 3:43 am
What's the error?
Mac
irealms
Forum Contributor
Posts: 215 Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds
Post
by irealms » Fri Oct 15, 2004 3:48 am
unexpected TL_NUMBER, T_VARIABLE or $
irealms
Forum Contributor
Posts: 215 Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds
Post
by irealms » Fri Oct 15, 2004 4:31 am
erm i had a varible $7orders, it didn't like the 7
irealms
Forum Contributor
Posts: 215 Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds
Post
by irealms » Fri Oct 15, 2004 4:36 am
the query now seems to not be drawing from 7 days, i have 5 orders in database from october, 4 from 14th and one from 4th and it's counting 5 as in the last 7 days, though the one from the 4th shouldn't be counted.
mudkicker
Forum Contributor
Posts: 479 Joined: Wed Jul 09, 2003 6:11 pm
Location: Istanbul, TR
Contact:
Post
by mudkicker » Fri Oct 15, 2004 5:13 am
can you post your code please?
irealms
Forum Contributor
Posts: 215 Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds
Post
by irealms » Fri Oct 15, 2004 5:25 am
$weekorders = "SELECT * FROM orders WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= dateadded AND status!='Quote'";
$weekordersq = mysql_query($weekorders, $db_conn) or die("Query $weekordersq Failed".mysql_error());
irealms
Forum Contributor
Posts: 215 Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds
Post
by irealms » Fri Oct 15, 2004 5:38 am
hmm don't know what i did but it's working now i think