Jump to content
orsino

db->query question

Recommended Posts

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 

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...