Tilted Forum Project Discussion Community - View Single Post - [PHP

mpedrummer2 · 02-27-2004, 11:31 AM

I'm designing a database system for monitoring/tracking service calls. Currently, there's about 6 users. However, in a few weeks, it should come out of beta and go live with 50 or so...

Here's my issue: if two (or more) people are editing the same call at the same time, whomever hits "update" last, wins. Their information overwrites everyone elses.

How do I get around this? I don't want to actually lock the row by switching to InnoDB...our current system does that, and people always somehow screw up the exit process and the row stays locked until someone with direct access can fix it.

I'd like to do something like forums do...where they show you "Users currently browsing this forum". I have it figured out how to deal with that on the way in, easy enough. How do I get the site to figure out when they exit a call using the back button, or simply closing the browser?

I suppose eventually I'll download an open-source forum and take a look at the code to see what I can figure out.

Anyone have a better idea (I'm sure)?

Thanks
MPEDrummer

02-27-2004, 11:31 AM	#1 (permalink)
mpedrummer2 Insane	[PHP - MySQL] Concept question... I'm designing a database system for monitoring/tracking service calls. Currently, there's about 6 users. However, in a few weeks, it should come out of beta and go live with 50 or so... Here's my issue: if two (or more) people are editing the same call at the same time, whomever hits "update" last, wins. Their information overwrites everyone elses. How do I get around this? I don't want to actually lock the row by switching to InnoDB...our current system does that, and people always somehow screw up the exit process and the row stays locked until someone with direct access can fix it. I'd like to do something like forums do...where they show you "Users currently browsing this forum". I have it figured out how to deal with that on the way in, easy enough. How do I get the site to figure out when they exit a call using the back button, or simply closing the browser? I suppose eventually I'll download an open-source forum and take a look at the code to see what I can figure out. Anyone have a better idea (I'm sure)? Thanks MPEDrummer __________________ My sig can beat up your honor student.