What is wrong..

[Lamez]

I hate using the update function, what am I doing wrong here?

 

	$q = "UPDATE `points` SET 1=$a, SET 2=$b, SET 3=$c, SET 4=$d, SET 5=$e, SET 6=$f WHERE id=$id";

mysql_query($q)or die(mysql_error());

 

I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1=0, SET 2=0, SET 3=0, SET 4=0, SET 5=0, SET 6=0 WHERE id=1' at line 1

 

 

[KrisNz]

I think you need `` around your column names. as in `1`=$a.

[Lamez]

I just tried that, and it did not work.. :-\

[KrisNz]

Oh yeah, you also only SET once

ie.

$a = 10;
$b = 20;
$q = "UPDATE points SET `1`=$a,`2`=$b ";