SQL Help

Xerox · 05-11-2005, 22:51

Hello,
I am getting a SQLl error

Quote:

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 'd m Y')','Never')' at line 1

with this code

PHP Code:

  $query = "INSERT INTO users (username, password, email, name, gender, dob, country, postalcode, timezone, regdate, lastlogin) VALUES('$username','$password','$email','$name','$gender','$dob','$country','$postalcode','$timezone','$regdate','$llogin')";

Can anyone help me please i do not know why i am getting this error
Thanks
Xerox

Dr John · 27-11-2005, 10:21

You have two fields that are dates - regdate and lastlogin. One of them will be a different format to what you have set in the database.

print (echo) the values of regdate and lastlogin to the screen and compare their format with what the database is expecting. As a guess one includes hours mins secs, or is yymmdd instead of ddyymm or whatever.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

27-11-2005, 10:21	#2 (permalink)
Dr John Newbie Join Date: Apr 2005 Posts: 7 iTrader: 0 / 0%	You have two fields that are dates - regdate and lastlogin. One of them will be a different format to what you have set in the database. print (echo) the values of regdate and lastlogin to the screen and compare their format with what the database is expecting. As a guess one includes hours mins secs, or is yymmdd instead of ddyymm or whatever.