Menu
Community /Pin to ProfileBookmark
@NogDogAug 07.2007 — #Firstly, string literals in SQL must be quoted just as they are in MySQL. The variables you are passing to MySQL in the VALUES list of the query will be converted to their actual values when they are sent to MySQL, so they will need to be quoted if they are not numeric values. Also, you can use the following pattern to help you debug, by showing you the actual query string as it was sent to MySQL if it fails:
Error in simple MySQL code
Hi, not sure what I’ve done wrong here…
I have the following code
[CODE]
mysql_query(“INSERT INTO bandwusers (firstName,lastName,gender,age,email,dateRegistered,postalAddress,username,
password,newsletter) VALUES
($firstName,$lastName,$gender,$age,$email,$dateRegistered,$postalAddress,$username,$password,$newsletter)”) or die(mysql_error());
However I’m getting error messages saying:
“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 ‘,Male,,,2007-8-7,,,hhyrl1l,Yes)’ at line 1”
[Note, the values it refers to are the values I’m trying to insert into the db]
This is such a simple little prob, but can’t think what I’ve done wrong… can anyone help? Thanks so so much!! ?
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogAug 07.2007 — #Firstly, string literals in SQL must be quoted just as they are in MySQL. The variables you are passing to MySQL in the VALUES list of the query will be converted to their actual values when they are sent to MySQL, so they will need to be quoted if they are not numeric values. Also, you can use the following pattern to help you debug, by showing you the actual query string as it was sent to MySQL if it fails:[code=php]
$query = "INSERT INTO bandwusers (firstName, lastName, gender, age, email,
dateRegistered, postalAddress, username, password, newsletter)
VALUES ('$firstName', '$lastName', '$gender', $age, '$email', '$dateRegistered',
'$postalAddress', '$username', '$password', '$newsletter')";
$result = mysql_query($query) or die("Insert failed ($query): " . mysql_error());
[/code]