Re: SQL Query syntax error... Help?

In the future, to make things easier on yourself, when you get a query syntax error add an "echo $sql;" line right before your query. Almost every time I have a query problem, that solves it. -- Plutarck Should be working on something... ...but forgot what it was. ""Scott VanCaster"" <scott@vancaster.net> wrote in message news:9bd394$ikn$1@toye.p.sourceforge.net... > 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 >