Thanks for the reply Manual.

The updating IS done with one single query - but the problem is that if two 
people are editing the same car, the second update will overwrite the 
first.  Not a huge problem - and the chance of it happening is almost nil - 
but there is still the possibility..  Changing databases seems a little 
extreme - and not possible with our web host.


At 20:03 10/07/2001 -0300, you wrote:
>Tom Peck wrote:
> >
> > Hi
> >
> > The company I work for has recently developed a Car Dealer type site, which
> > acts as a large on-line used car yard.  Currently the MySQL database
> > holding the cars is added too / edited / deleted by one person employed for
> > the job - but we hope to expand to allow the Dealers themselves admin
> > rights to their on-line cars.
> >
> > I have begun development of a Dealer Admin area - but have a couple of
> > questions regarding this:
> >
> > 1)  Would any sort of Table Locking be needed for this -  for example if
> > two people were trying to update the same car, at the same time etc etc..
>No, if updating is done with a single query.
> > 2)  If yes, is there any on-line documentation on this?
> > 3)  What other problems could arise if this was implemented?
>It depends on what you really want to do.
>Anyway, MySQL has LOCK TABLES but I don't recommend to use them without
>proper because you inadvertdly may leave the database locked. The latest
>versions also support transactions. It's a bit awkward but it works,
>although the recommendation is the same.
>Maybe you want to try other databases that handle transactions more
>efficiently like Oracle, or PostgreSQL if you can't afford a commercial
>If you are not sure about switching to other databases, you may want to
>try Metabase which is a database abstraction package that lets you write
>portable database applications. That way, you may switch (or not) to
>another database later without changing your application code.
>Metabase is free and is available here:
>Manuel Lemos
>PHP Database Mailing List (
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP Database Mailing List (
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