----- Original Message -----
From: "Joao Andrade" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 26, 2003 12:31 AM
Subject: [PHP] manual key generation
>
> 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?
As the error-text says... mysql_query returns a result id
use this code instead:
$mri = mysql_query("SELECT MAX(quotation_id)+1 from quotations");
$result = mysql_fetch_row($mri);
$new_key = $result[0];
see the php.net website for details !
// Ewout
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
