PHP & mySQL row locking

[skiflyer]

Will a PHP mySQL solution allow me to lock rows of a database while I'm working with them, or will I need to manage this myself?

If so is the solution which is immediately popping to my head, an extra smallint field in each table to hold the different lock levels, the best approach, or is there a better standard more often used?

-Rob

 

[sleipnir214]

What are you trying to lock and why? Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[skiflyer]

Nothing yet, still in the planning stages.

But I will have certain things, that once checked out, I won't want other people to be able to modify. Hard to come up with a concrete example as I'm so early in on this.

I might not, the more I try to think of an example, the more I think of more elegant solutions... but I just have this feeling this is going to creep up in at least one place given the nature of the application.

-Rob