devon Posted June 5, 2003 Posted June 5, 2003 Hello, please can anybody help me. In admin I get this error message and no year to select is shown. 1064 - You have an error in your SQL syntax near 'DAYOFMONTH(date)' at line 1 select DAYOFMONTH(date) as name, count(counter) as value from visitors where MONTH(now()) - MONTH(date) < 1 group by DAYOFMONTH(date) [TEP STOP] Devon Quote
Ian-San Posted June 5, 2003 Posted June 5, 2003 Please post here as you may get a better response - I dont normally check all the posts these days due to other work pressures. http://www.oscommerce.com/forums/viewtopic.php...p=177992#177992 I dont have an answer for you but I have anyway posted my reply in the above forum. Quote Ian-san Flawlessnet
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.
Note: Your post will require moderator approval before it will be visible.