I have a problem with a query:

I use an application where users can post messages. The messages are stored
in two tables that are related by the id of the new created message. I get
the last id with the following query: "select max(id) as maxid from
tasker_app"
The forum has many users and sometimes it happens that there are multiple
inserts before I can receive the last id.
Is it possible to stop inserts until I have finished both inserts?


Thank you,
Richard Brenner



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to