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"" <[EMAIL PROTECTED]> wrote in message
9bd394$ikn$[EMAIL PROTECTED]">news:9bd394$ikn$[EMAIL PROTECTED]...
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
