2. PHPRunner General questions
  3. [SOLVED]  custome update query to reduce by 1 the value of the field
This topic is locked
[SOLVED]

 custome update query to reduce by 1 the value of the field

 		8/23/2013 9:11:59 AM
PHPRunner General questions
C
 chrispa author

hi i have following working fine and set credits to value 4.
what i need is when i run that query to substract the existing value of credits by 1 i.e. from 4 to 3 etc.
CustomQuery("update user set credits='4' where user = '".$values['main_tracking_user']."'");
thanks in advance
C
 		cgphp 8/23/2013
CustomQuery("update user set credits = credits - 1 where user = '".$values['main_tracking_user']."'");
C
 		chrispa author 8/23/2013

THANK YOU VERY MUCH !!!