solved db->query question

[orsino]

hey 

i have this line in my daily cron 

$db->query("UPDATE `users` SET `steps`=`steps`= 100 WHERE `steps` < 100");

 

so steps in users schould get 100 each day 

but the line doesnt work 

did i overlook something ?  or is it sql related ? 

 

sql is  steps int11 unsigned 

 

[Mark Topper]

Depending on what you are trying, this first query will set the step to be 100: UPDATE `users` SET `steps` = 100 WHERE `steps` < 100
The next one will add 100 to the step: UPDATE `users` SET `steps` = `steps` + 100 WHERE `steps` < 100

[ags_cs4]

 `steps`=`steps`= the error is here just use one  `steps`=

[Curt]

$db->query("UPDATE `users` SET `steps`= 100 WHERE `steps` < 100");

[orsino]

already found it  thx