Jump to content


Photo

Please help- Mysql syntax error


  • Please log in to reply
2 replies to this topic

#1 geedee

geedee
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 22 May 2006 - 10:39 AM

hi all,can someone please help.I get the same error msg when someone tries to register on my site.can someone help please.Much appreciated if you can.thanks

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 ' 1, 10, 10, 0, '2006-05-21 19:07:28', 0, '2006-05-21 19:07:28', 'no', 'Un-verifi' at line 1


#2 semtex

semtex
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 22 May 2006 - 11:34 AM

sure the datetime fields are "datetime" and not "date"?

is this the mysql_error() message?

#3 samshel

samshel
  • Members
  • PipPipPip
  • Advanced Member
  • 837 posts

Posted 22 May 2006 - 11:43 AM

Hello,

Please post your complete SQL query.
If possible, echo the query before you are executing in the script and post it here.


Cheers,
SamShel
-----------------------------------------------
--: FUTURE IS LINUX :--
-----------------------------------------------




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users