Results 1 to 1 of 1

Thread: [Resolved] Need Help With SQL Error

Threaded View

  1. #1

    Thread Starter
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256

    [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.
    My evil laugh has a squeak in it.

    kristopherwilson.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width