Hi,
> TABLE: shop
> FIELD: article int unsigned auto_increment
>
> 1) insert into shop values (null);
> 2) select max(article) from shop;
for that purpose, you can use the mysql_insertid() function.
Rgds,
Tfr
--==< [EMAIL PROTECTED] >==< MySQL development team >==< Tallinn / Estonia >==--
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
