RE: [PHP] SQL Query syntax error... Help?

scott, try the entire SQL statement without single quotes around those variables. except for when your setting the WHERE part. Try: $sql ="UPDATE members SET ". "name=$name, ". "email=$email, ". "icq=$icq, ". "password=$password, ". "loginid=$loginid, ". "countryid=$countryid, ". "gtlogin=$gtlogin, ". "gtpass=$gtpass, ". "swirvelogin=$swirvelogin, ". "swirvepass=$swirvepass ". "WHERE id='$id'" ; I could be wrong though, but just my two cents. chris www.variancecreations.net -----Original Message----- From: Scott VanCaster [mailto:scott@vancaster.net] Sent: Sunday, April 15, 2001 5:20 PM To: php-general@lists.php.net Subject: [PHP] SQL Query syntax error... Help? I've only been trying to learn this stuff for a few days and thought I was on a roll, but now have run into a problem I don't get at all. In my script I have the following sql query and am receiving the following error when it executes "You have an error in your SQL syntax near '' at line 1." Any idea what my problem is? I removed the WHERE id=$id and it works, but updates every record of course :( I'm lost here. Thanks for any help. $sql ="UPDATE members SET ". "name='$name', ". "email='$email', ". "icq='$icq', ". "password='$password', ". "loginid='$loginid', ". "countryid='$countryid', ". "gtlogin='$gtlogin', ". "gtpass='$gtpass', ". "swirvelogin='$swirvelogin', ". "swirvepass='$swirvepass' ". "WHERE id=$id" ; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net