l.com> cc:
Subject: RE: [PHP-DB] Last ID from
database?
> -Original Message-
> From: Chris Payne [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 26, 2002 3:57 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Last ID from database?
>
>
> Hi there everyone,
>
> How Can I grab just the LAST ID from a database in MySQL with PHP
> easily?
Whi
Hi Chris,
On Wed, 26 Jun 2002, Chris Payne wrote:
> Hi there everyone,
>
> How Can I grab just the LAST ID from a database in MySQL with PHP
> easily?
http://devrim.oper.metu.edu.tr
-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
$sql= "SELECT ID FROM table_name ORDER BY ID DESC limit 1"
.
..
...
-- jp
At 15:56 26/06/02, Chris Payne wrote:
>Hi there everyone,
>
>How Can I grab just the LAST ID from a database in MySQL with PHP
>easily?
>
>Thanks you :-)
>
>Chris
>
>
>---
>Outgoing mail is certified Virus Free.
>Check
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, June 26, 2002 1:59 PM
To: 'Chris Payne'
Subject: RE: [PHP-DB] Last ID from database?
It depends on if you just inserted it, if you did:
mysql_insert_id
if not, you'll need to do a query for SELECT max(ID)
Chris,
$insertID = mysql_insert_id();
Check http://www.php.net/manual/en/function.mysql-insert-id.php for
additional info.
Rich
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 3:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Last I