On Fri, Jul 17, 2009 at 11:12 AM, Jason Pruim<jason@xxxxxxxxxxxxxx> wrote: > Hi everyone! > > So some of you may have noticed that I have been away for quite awhile... > Been trying to get settled (Moved across the country) and getting a job. > > And now that that is done I have a question about a project that I might be > doing for my current employer and want to do it properly. > > If all goes through, I'll be writing an online database that upwards of 10 > people will be using at various times through out the day. Basically, in a > form they fill out a model number, customer name, phone number etc. etc.. > And then submit the form. After submitting they need to write the log number > on some paperwork. If I have 2 people submit the form at the same time, I'm > thinking I could end up with a race condition and they might get the wrong > log number (The log number is simply a consecutive record number) > > Do I need to be reading up on locking tables/rows? Or in my situation as > I've briefly described it do I not have to worry about it? Or is there a > third door with the magic bullet that will solve all my problems? :) > > Any advice is greatly appreciated as always, RTFMing is good as well, as > long as M is defined :) > > I'm not afraid of google either, just need the right terms to hit it with so > I don't go into "search overload" as the commercials for a rival search > engine claim :) > > Thanks Everyone! > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Hey Prune, nice to see ya again. Is the log number formatted? If not, just use an autonumber in the database. Most allow you to pick the starting point so setting the value shouldn't be a problem. -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php