Page 1 of 1

MySQL Locking the Database or Table

Posted: Sun Jul 09, 2006 9:38 am
by tecktalkcm0391
I want to have a PHP script that updates every column 1 on my user database, and I was thinking about this: If I did a count rows and then updated every row, but then i thought "What if while the update was processing a new user was added, then they wouldn't get updated."

So is there a way to lock the database until its done or something?

Thanks

----
My Project:
I have a security code that is created every X days, and every users password is decrypted with the old code then encrypted with the new code. And then my website uses the new code until a newer one comes up.

Posted: Sun Jul 09, 2006 9:54 am
by feyd
Why is this in PHP - Code? Moved to Databases. :roll:

Posted: Sun Jul 09, 2006 10:06 am
by Roja