|
-
Jun 26th, 2004, 10:24 PM
#1
Thread Starter
Stuck in the 80s
[Resolved] Need Help With SQL Error
EDIT: Nevermind. The SQL statement that I was echoing out (in my quote below) was the wrong one. This was not the SQL statement that was causing the error. I fixed the problem, but I can't delete this post, so please disregard.
I'm getting this error with one of my scripts (note the SQL statement is included):
SELECT DISTINCT DATE_FORMAT(postedOn, '%M 01, %Y') FROM vbsNews_news ORDER by postedOn DESC
An error has occurred in display.php:
You have an error in your SQL syntax near 'DATE_FORMAT(postedOn, '%m-%y') = '04-04'' at line 1
The SQL statement works perfectly fine on my local test machine (MySQL 3.23.58), but gives the above error on my remote server (MySQL 3.23.56).
I can't figure out what's causing it. Is it possible that I'm doing something that's not available until *.58? Or is there something I'm missing?
Last edited by The Hobo; Jun 26th, 2004 at 10:34 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|