SQL Query syntax error... Help?
| From: | Scott VanCaster | Date: | Sun, 15 Apr 2001 21:20:07 +0000 |
| Subject: | SQL Query syntax error... Help? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-48651@lists.php.net to get a copy of this message | ||
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" ;