Hi...
I want to say some words about the Table Locking problem.
I had a problem something like this one, I find solution for this by locking
only the item that will updated. I added two areas one that has a value 0 or
1 giving it is currently used by someone, and second time it is started to
In article [EMAIL PROTECTED], Emre Erdogan wrote:
Hi...
I want to say some words about the Table Locking problem.
I had a problem something like this one, I find solution for this by locking
only the item that will updated. I added two areas one that has a value 0 or
1 giving it is
I need to be sure, thath nobody else will can write on some tables until I
don't append obout 4-500 records in these tables.
But until now I never used table locking in MySQL and I didn't found
information about this ( like examples ).
Is there a problem with locking if PHP uses same userpass for
I have an orders with one main record in table1 ( client, date, e.t.c. ) and
detail description in table2 ( all materials with quant, price, e.t.c. )
and I save data in table1 for positions (range of id - autoinc field of
records in table2) for detailed data of order . And I don't want someone
John W. Holmes [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Michael Gale wrote:
For the UPDATES ... what would have it in theory two people hit the
UPDATE
button at the exact same time ? Would one just over write the other ...
cause that is fine ?
Hi Michael,
is it really OK
Yes .. it is ok - the data that I allow to get updated like this is not that important
and when a update is made it
would be two people entering the same data anyways.
It is just for contact info for people in the db ... like there current phone or
address if it changes.
Michael.
On Fri, 9
Hi,
I have the following situation: I have to prevent users to write at the same
time in one table in PHP script.
Is there a way the PHP to understand, thath another user is filling table,
and to wait before begin to fill data?
Thanks in advance!
--
PHP Database Mailing List
Rosen wrote:
I have the following situation: I have to prevent users to write at the same
time in one table in PHP script.
Is there a way the PHP to understand, thath another user is filling table,
and to wait before begin to fill data?
Most databases have a LOCK command that you can issue. The
Is thath mean, thath, when one user is addind records to table, and lock
it - when another user is trying to get the max field value for some field,
the script will waiting the first user to unlock table and then to see the
max value of some field in a table ?
John W. Holmes [EMAIL PROTECTED]
On Friday 09 July 2004 07:09, Rosen wrote:
Is thath mean, thath, when one user is addind records to table, and lock
it - when another user is trying to get the max field value for some field,
the script will waiting the first user to unlock table and then to see the
max value of some field in
Thanks, but can you give me a sample PHP script with MySQL database, whitch
do this?
Thanks
Jason Wong [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Friday 09 July 2004 07:09, Rosen wrote:
Is thath mean, thath, when one user is addind records to table, and lock
it - when
And if I perform LOCK tables ... nobody can;t write on these tables,
until I don't perform UNLOCK TABLES ?
If something happens ( I mean if some my queryes fails) ?
Jason Wong [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Friday 09 July 2004 07:24, Rosen wrote:
Thanks, but can
and will
incorporate your suggestions into my work in the future.
Chuck
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 11:32 AM
To: Mayo, Chuck
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Table locking to prevent duplicate inserts
Hi all,
Hope you'll forgive the duplicate post but the list seems to be hopping
today (unlike the friday afternoon I sent the original query)... since
everyone seems to be awake today I thought I'd try it again:
---
I'm working through an issue that I'm sure everyone else has
Mayo, Chuck wrote:
Hi all,
Hope you'll forgive the duplicate post but the list seems to be hopping
today (unlike the friday afternoon I sent the original query)... since
everyone seems to be awake today I thought I'd try it again:
Sorry about that; I hate to keep my employers waiting. BTW, I
Hi all,
I'm working through an issue that I'm sure everyone else has already figured
out, how to lock a table during a series of INSERTS to prevent duplicate
entries:
The scenario is this:
OS Solaris 8
PHP 4.2.3
MySQL 3.23.53
Table type: MyISAM
1) A user submits a form containing about
(PHP-DB folks, ignore this top question - unless you want to answer)
Which type of DB/Table provides table locking while a process is
altering data? I don't care for locking while using SELECTs, but I do
need locking when something's being INSERTed or UPDATEd, so I won't get
two
17 matches
Mail list logo