On Friday 16 August 2002 17:37, Christian Ista wrote:
> In an MySQL table, I insert some records. Before each insert (just
> I do a "Select max() ..." and I increment the result by one, to give a
> number (unique), and I have an auto_incremente field too.
Not sure why you would have a field that is manually incremented and also one
that is auto_incremented.
> I'd like to know if there is a mechanism in PHP, if several person do
> the same thing in the same moment, to not have several record with the
> same number.
PHP does not have such a mechanism. You can lock the relevant table, then
query, then increment and update value, then unlock table. For further info
1) ask on php-db list
2) ask on mysql list
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
What ever happened to happily ever after?
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php