sql help

[Greg Brant]

You have an error in your SQL syntax near ''ws2Signups' SET ('name',
'email') = ('gregrpimp', 'g@b.com') WHERE (id = '1') A' at line 1

the full query is

"UPDATE 'ws2Signups' SET ('name', 'email') = ('$name', '$email') WHERE
(id = '$id') AND ('position' ='$i')"

the collumns 'name' and 'email' are varChar 255, 'id' and 'position'
are integers

[Mark Kuiphuis]

Re: sql help

$query = UPDATE ws2signups SET name = '$name', email = '$email WHERE id
= '$id' AND position = '$i'";

Mark

Greg Brant wrote:[color=blue]
> You have an error in your SQL syntax near ''ws2Signups' SET ('name',
> 'email') = ('gregrpimp', 'g@b.com') WHERE (id = '1') A' at line 1
>
> the full query is
>
> "UPDATE 'ws2Signups' SET ('name', 'email') = ('$name', '$email') WHERE
> (id = '$id') AND ('position' ='$i')"
>
> the collumns 'name' and 'email' are varChar 255, 'id' and 'position'
> are integers[/color]