As others have obviously pointed out using MAX() is the way to go. Need I
mention that you can also insert values of your own making into an
auto_increment column as long as they are not already used by some other
In your case since you have old records with IDs of their own making, you
can probably insert them at the beginning before the newer records actually
use an auto - generated ID.
Also by using mysql_insert_id () in PHP you can get the last inserted
----- Original Message -----
From: "CÚsar Aracena" <[EMAIL PROTECTED]>
To: "'PHP DB List'" <[EMAIL PROTECTED]>; "PHP General List"
Sent: Thursday, June 13, 2002 12:06 AM
Subject: [PHP-DB] Querying for MAX
I'm sorry if this mensaje is posted twice. I sent it yesterdays, but
then my ISP had problems with e-mail and I lost dozens of them and don't
know if sent OK.
What I'm trying to do here is not inside PHP nor MySQL books I have. I
need to query the DB to look the max result in a column. That is, if I
have affiliate members with ID going from 1 to 10, get the query to know
that the last member added was 10 so I can add member 11 without using
auto_increment, because I need to insert old members too which already
have ID numbers. Is that possible?
Thanks in advance,
Cesar Aracena <mailto:[EMAIL PROTECTED]>
CE / MCSE+I
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php