Thread: Sql Insert
View Single Post
Old Nov 16th, 2005, 6:29 AM   #2
tempest
Programming Guru
 
tempest's Avatar
 
Join Date: Oct 2004
Posts: 1,041
Rep Power: 5 tempest is on a distinguished road
Send a message via ICQ to tempest Send a message via AIM to tempest Send a message via Yahoo to tempest
[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 )...
__________________

tempest is offline   Reply With Quote