UPDATE $vaiable SET $variable

[Anon]

Shouldn't this work?

++$variable;

setCookie ("variable","$variable", time()
[phone], "/");

$result = mysql_query("UPDATE $table SET $variable=1 WHERE username ='$loginusercookie'", $Connect);

The problem is with SET, unless i specify a field name to SET it doesnt seem to work. All i want to do is increment the value of what is being SET by 1 each time the script is run

[Anon]

Then shouldn't that be:

UPDATE $table SET field_name = $variable ...

?

AFAIK, a field name cannot start with a number, so therefore it can't be a number either...

Diego

[Anon]

Well see what i am trying to do is actually UPDATE different fields with the same value, not update the same field with different values.

But if a fieldname can not be a number, what if i did this...

UPDATE $table SET testfield$Variable = 1

so testfield would be the field name and it would have a number after it based on whatever the value of $Variable was.
such as testfield1, testfield2, and so on...

[Anon]

You could do that...but make sure first that you have all those fields! What if someone attached in their query string:

script.php?Variable=1000

Are you going to have the field testField1000? Just do error checking before you update.

Diego