Programming Forums > Web Development and Design > Other Web Development Languages

Intimidat0r · Nov 15th, 2005, 11:49 PM

ok i feel retarted right now. i have this sql query:

$query_result = mysql_query("INSERT INTO users ('username', 'password', 'email', 'security_question', 'answer', 'zipcode', 'state', 'country', 'city', 'telephone', 'aim', 'msn') VALUES ('".$username."','".$password."','".$_POST['email']."','".$security_question."','".$answer."','".$zipcode."','".$state."','".$country."','".$city."','".$telephone."','".$aim."','".$msn."',", $conn) or die(mysql_error());

and its dying with this:

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 ''username', 'password', 'email', 'security_question', 'answer',

and yes all the variables are declared, im properly connected, etc., etc.

tempest · Nov 16th, 2005, 6:29 AM

[php]$query_result = mysql_query("INSERT INTO users ('username', 'password', 'email', 'security_question', 'answer', 'zipcode', 'state', 'country', 'city', 'telephone', 'aim', 'msn') VALUES ('".$username."','".$password."','".$_POST['email']."','".$security_question."','".$answer."','".$zipcode."','".$state."','".$country."','".$city."','".$telephone."','".$aim."','".$msn."')", $conn) or die(mysql_error());[/php]

On the end of your SQL statement you were still using "','" . $variable . "'," and at some point you have to end it with a )...

Intimidat0r · Nov 16th, 2005, 3:20 PM

ah that solved my problem. thank you.

Intimidat0r · Nov 16th, 2005, 9:04 PM

now its giving me another one:

(Toggle Plain Text)

$query_result = mysql_query("INSERT INTO users (username, password, email, security_question, answer, zipcode, state, country, city, telephone, aim, msn, character, league) VALUES ('".$username."','".$password."','".$_POST['email']."','".$security_question."','".$answer."','".$zipcode."','".$state."','".$country."','".$city."','".$telephone."','".$aim."','".$msn."','".$character."','".$league."')", $conn) or die(mysql_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 'character, league) VALUES ('intimidat0r','b1076926499e320b667dd

any help would be appreciated. thanks.

Ooble · Nov 17th, 2005, 11:23 AM

Copy your SQL statement and echo it - that'll help you see where you're doing wrong.

Intimidat0r · Nov 17th, 2005, 7:19 PM

i actually did that already, and its weird, i cant see anything wrong with it.

heres the parsed query:

Quote:

INSERT INTO users (username, password, email, security_question, answer, character, league) VALUES ('intimidat0r','b1076926499e320b667dd1a3c8df1c99','intimidat0r.bb@gmail.com','What is your favorite pet\'s name?','Toby','Bully','Infamous')

Pizentios · Nov 18th, 2005, 9:14 AM

a stab in the dark: try a ; at the end of your statment. You shouldn't need it, but it won't hurt it ether.

DaWei · Nov 18th, 2005, 10:02 AM

The two latest quotes representing your problem are different. What gives? If you're whittling back to exclude possibly mislabeled names, it isn't a bad idea. Just keep whittling. We can't know what the real column names (or aliases) or variable names are. The way I generally do it is construct a sql string, then pass that to the query. If it fails, and I can't see why, I can put an echo of the string. When it finally works, I can just comment it out.

Pizentios · Nov 18th, 2005, 10:45 AM

Another thing to check is the data types that you have for your columns. If you have column that is Char(10) and you try and put 20 characters into it, it will fail.

Nov 16th, 2005, 6:29 AM	#2
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 5	[php]$query_result = mysql_query("INSERT INTO users ('username', 'password', 'email', 'security_question', 'answer', 'zipcode', 'state', 'country', 'city', 'telephone', 'aim', 'msn') VALUES ('".$username."','".$password."','".$_POST['email']."','".$security_question."','".$answer."','".$zipcode."','".$state."','".$country."','".$city."','".$telephone."','".$aim."','".$msn."')", $conn) or die(mysql_error());[/php] On the end of your SQL statement you were still using "','" . $variable . "'," and at some point you have to end it with a )... __________________

Nov 16th, 2005, 3:20 PM	#3
Intimidat0r Hobbyist Programmer Join Date: May 2005 Location: Don't know, but the padded walls are a nice touch. Posts: 126 Rep Power: 0	ah that solved my problem. thank you. __________________ Children in the dark cause accidents, and accidents in the dark cause children. http://www.ronincoders.org

Nov 17th, 2005, 11:23 AM	#5
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Copy your SQL statement and echo it - that'll help you see where you're doing wrong. __________________ Me :: You :: Them

Nov 18th, 2005, 9:14 AM	#7
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	a stab in the dark: try a ; at the end of your statment. You shouldn't need it, but it won't hurt it ether. __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Nov 18th, 2005, 10:02 AM	#8
DaWei Resident Grouch Join Date: Jun 2005 Posts: 6,453 Rep Power: 10	The two latest quotes representing your problem are different. What gives? If you're whittling back to exclude possibly mislabeled names, it isn't a bad idea. Just keep whittling. We can't know what the real column names (or aliases) or variable names are. The way I generally do it is construct a sql string, then pass that to the query. If it fails, and I can't see why, I can put an echo of the string. When it finally works, I can just comment it out. __________________ Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code. Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Nov 18th, 2005, 10:45 AM	#9
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	Another thing to check is the data types that you have for your columns. If you have column that is Char(10) and you try and put 20 characters into it, it will fail. __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

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

Programming Forums > Web Development and Design > Other Web Development Languages

Sql Insert