[SOLVED] UPDATE values everytime a script runs

[dreamwest]

I want to update values everytime a script runs

 

Example:

 

$result = mysql_query("UPDATE video SET viewnumber='2' WHERE viewnumber='0'") 
or die(mysql_error());

 

Im trying to increase the number by 2 everytime the script runs. But i cant see how i can do this when WHERE viewnumber='0' can be any number

[bubbasheeko]

$result = mysql_query("UPDATE video SET viewnumber='2'");

 

That's what you need to do based on how you described it.

 

It doesn't matter what viewnumber is, you just want to increase it by two. 

 

But i cant see how i can do this when WHERE viewnumber='0' can be any number

[corbin]

$result = mysql_query("UPDATE video SET viewnumber='2'");

 

That's what you need to do based on how you described it.

 

It doesn't matter what viewnumber is, you just want to increase it by two. 

 

But i cant see how i can do this when WHERE viewnumber='0' can be any number

 

 

 

 

That will set it to 2 every load.  I think he wants to increase it by 2.

 

UPDATE video SET viewnumber = viewnumber + 2;

[dreamwest]

That will set it to 2 every load.  I think he wants to increase it by 2.

 

UPDATE video SET viewnumber = viewnumber + 2;

 

This works. Thanks!

[bubbasheeko]

LOL That's right.  Thanks for the correction!