Re: [PHP] manual key generation

[Marek Kilimajer]

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.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php