Re: manual key generation

Your question has been answered, I just want to add that you should lock your table before this query and release the lock after the new row is inserted. Joao Andrade wrote:

    Aloha!

    I have a script that inserts a new row in a table called "quotations",

which has a primary key called "quotation_id". "quotation_id" is an int(11) type. When I enter:

    SELECT MAX(quotation_id)+1 from quotations

    I get simply the number 7 (which is ok)

    But when I do:

    $new_key = mysql_query("SELECT MAX(quotation_id)+1 from quotations")

    I get $new_key = Resource id #3

    What the hell is that supposed to mean?

    Thanx a bunch.