| Yea, the problem isn't your interface, it's your database.  MySQL is really a flat file system with a SQL front end, so there's not a lot you can do there..  You might think about implementing postgreSQL as an alternative, which might be able to support the per-user record locking & report that back on query.  I know that Oracle would do it without question, but that's definitely $$$ beyond. 
				__________________I'm gonna be rich and famous, as soon I invent a device that lets you stab people in the face over the internet.
 |