Hi Ron,
My Scenario is if two users open an existing record with data already in
the fields. They then add
some information to the end of a field with data.
Now when they click update the last user/browser gets written to the db,
where the first users data is over written.
I thought
* Ron McKeever
I thought update is for existing records and insert is to add new records?
That is correct.
My Scenario is if two users open an existing record with data
already in the fields. They then add some information to the
end of a field with data.
They add information, you say? As
On Fri, 16 Jan 2004 13:43:55 -0800
Ron McKeever [EMAIL PROTECTED] wrote:
Scenario 1:
I have noticed that if two users open a record to edit it
in two different browsers
and they edit the same field and then click update,
the last user/browser gets written to the db,
where the first users
clicks update second
user b's line is added/appended to record 5, user a's line is overwritten
not even seen.
Ron
-Original Message-
From: Batara Kesuma [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 17, 2004 4:20 AM
To: [EMAIL PROTECTED]
Subject: Re: Do I need Innodb
Hi
I have a web app that use's PHP/Mysql/MYISAM. I am starting to think I need
INNODB table type.
Scenario 1:
I have noticed that if two users open a record to edit it
in two different browsers
and they edit the same field and then click update,
the last user/browser gets written to the db,