NEVERMIND! :)
-----Original Message-----
From: Scott VanCaster [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 15, 2001 6:05 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] SQL Query syntax error... Help?
Nevermind everyone, I'm an idiot :)
I had the case wrong. I needed $ID, not $id !!!!!
Thanks for the assistance though. Nice to know ya'll are here.
Scott
""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]
--
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]