Re: manual key generation
| From: | Ewout de Boer | Date: | Sat, 25 Oct 2003 22:49:14 +0000 |
| Subject: | Re: manual key generation | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-167586@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: "Joao Andrade" <joao66br@yahoo.com.br>
To: <php-general@lists.php.net>
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