FRIHOST • FORUMS • FAQ • TOS • BLOGS • DIRECTORY
You are invited to Log in or Register a Frihost Account!

Mysql set for all?

   Frihost Forum Index -> Scripting -> Php and MySQL
 


Diablosblizz
Hey I wanted to do something like this (if this was an actual code):

Code:
 mysql_query("UPDATE `members` SET `pollv` = '0' FOR ALL");


I want the code to reset all the pollv to 0 for ALL users. Is this possible?
DjinniFire
If I'm not mistaken you can just have

Code:

mysql_query("UPDATE `members` SET `pollv`='0'");


and it'll set every row with pollv to 0 and since it doesn't effect indexing of the table you don't need to order how you update the table

otherwise you could just count the rows of the table and put LIMIT $rows and it should update every row
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2007 Frihost, forums powered by phpBB.