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:[EMAIL PROTECTED]]
Sent: Sunday, April 15, 2001 5:20 PM
To: [EMAIL PROTECTED]
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: [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]
