Compatible Support Forums: SQL syntax error

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

SQL syntax error

#1 User is offline   Wilhelmus 

  • old hand
  • Group: Members
  • Posts: 1032
  • Joined: 21-December 04
  • LocationFinland

Posted 27 June 2005 - 04:39 PM

I get SQL syntax error 1064 on these pages:
http://www.ntcompatible.com/Help_installing_Might_&_Magic_for_blood_and_honor_t32530.html
http://www.ntcompatible.com/Help_installing_Might_&_Magic_for_blood_and_honor_t32531.html

FF 1.04 and IE 6.

Quote:

Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's' AND plonk_date > ('2005-06-27')' at line 1

0

#2 User is offline   Philipp 

  • Pooh-Bah
  • Group: Administrators
  • Posts: 1964
  • Joined: 15-July 99

Posted 27 June 2005 - 07:28 PM

Thanks Wilhelmus. This problem is now fixed.
0

#3 User is offline   Poacher 

  • stranger
  • Group: Members
  • Posts: 1
  • Joined: 04-July 05

Posted 04 July 2005 - 02:47 AM

How did you solve this problem cause i am in the same bother, with the same error. exept mine is this:

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '20688', '04c327436f', '',

this is the error identity which i found on the MySql website : #

Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)

Message: %s near '%s' at line %d

but still i dont know what it means.
0

#4 User is offline   Philipp 

  • Pooh-Bah
  • Group: Administrators
  • Posts: 1964
  • Joined: 15-July 99

Posted 08 July 2005 - 07:04 PM

Your are looking for addslashes:
http://at.php.net/manual/en/function.addslashes.php
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users