[SOLVED] Just Checking - Simple question

[Ell20]

Hey,

 

Is it possible to update a table like this:

 

$update2 = "UPDATE models SET referals='referals + 1' WHERE user_id='$userid'" or die(mysql_error());

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

 

Or do I have to query to find the current value then do current value + 1 then use that new variable?

 

Cheers

[papaface]

You can do that but do:

$update2 = "UPDATE models SET referals=referals + 1 WHERE user_id= '$userid'";
mysql_query($update2) or die(mysql_error());

[Ell20]

Thanks!