"Ashley M. Kirchner" <[EMAIL PROTECTED]> wrote:
> Steve Werby wrote:
> > Exactly.  It sounds like you're doing INSERTs so unless you're doing an
> > UPDATE or SELECT that can give unexpected results if another instance of
> > script is running at the same time or you have other scripts accessing
> > same files/tables that may run at the same time you're ok.
>     Well now, I didn't say I was only doing INSERTs.

Best guess based on limited information.  My bad.  :-)

> After parsing the email, I
> need to do a quick select in the DB to see if the customer (placing the
> already exists in our DB, and if they don't, just plain INSERT.
Otherwise, I
> need to do some more work, which will require an UPDATE on that same

It sounds like the only possible conflict is if a customer not in the system
places two orders that arrive at about the same time and the second SELECT
is done before the first INSERT is committed.  Experience suggests this
isn't very likely...so unlikely I wouldn't even worry about it unless
there's a reasonable probability that INSERTs would take a long time and new
customers would fire off two orders at the same time (double send in Outlook
or refreshing via a web form?)...and since I don't have all of the details
and I'm likely misinterpreting the whole application I'll leave it at that.

>     I'm probably going to break the DB into separate tables (one
containing the
> customer info, with a matching ID in another table which contains the
> orders).

FWIW, that's how I'd approach it.

>     (I know, this gets complicated by the minute. ;) )

Definitely harder than a "hello world", but it sounds manageable.  Have fun
with it!

Steve Werby
President, Befriend Internet Services LLC

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to