Thanks a Million my Friend. I've been struggling with this for days now <grin> -- Regards, John L. Creed pcExpressWay Consulting ***************************************** dBASE Gold Charter Member 210 ***************************************** http://www.pcexpressway.com ***************************************** "Niel Archer" <niel@xxxxxxxxxxxxx> wrote in message news:20070129224943.FD72.NIEL@xxxxxxxxxxxxxxxx > Hi > > Try using: > SHOW COLUMNS FROM db.table LIKE 'field_name%' > > and from the returned row, check the 'Extra' column for 'auto_increment' > > Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php