shawn allen wrote: >SELECT LAST_INSERT_ID() FROM foo; >- or - >php's mysql_insert_id() > beautiful - if only that MySQL manual was easier to use... > > -- Paul Bennett Internet Developer Teltest Electronic Design -------------------------- Phone : 64 4 237 0767 Web : http://www.teltest.com Wap : http://wap.teltest.com Email : paul at teltest.com --------------------------