FRIHOST • FORUMS • SEARCH • 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
Related topics
mySQL set-up on Frihost help please
MySQL Set-up Structure - Help!!!
Domain Help
MySQL scaling doubt
Joomla + mysql + Character set
Crazy language/character set in MYSQL! HELP, PLEASE!!!
Mudança de caracter set no MYSQL.
HTTP AUTH with PHP and mySQL		how to set up a server
Mysql error!
ALTER TABLE mySQL problem.
How to set authorisations -Windows sys / Apache webserver
MySQL DB Backup script - minor problem
MySQL Masters Binary Logs & Replication?
[MySQL (& php)] += in SQL?
Separating contents of MySQL row and put them in variables?		How to set up a wiki
error: Can't connect to local mysql server through socket
mySQL application install password problem in JSAS
[MySQL] Client does not support authentication protocol
What exactly does indexing mysql do?
MySQL HELP!!
build Universal Binary version of mysql administrator
MySQL database
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.