Jeffrey- Ah thank you. I was overcomplicating things as usual. I did look at mysql_insert_id but apparently didn't understand its use. regards, Ron -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Jeffrey Barke Sent: Monday, May 07, 2007 2:47 PM To: thelist at lists.evolt.org Subject: Re: [thelist] undefined index error - PHP and MySQL try: mysql_query(insert statement here); $histID = mysql_insert_id(); echo '<p>History ID is: ' . $histID . '</p>'; Jeffrey -- Cheers. Jeffrey Barke jeffery.barke at theMechanism.com Lead Developer, US theMechanism - New York City 440 9th Avenue, 8th Floor New York, NY 10001-1631 t: +1 212.404.3150 c: +1 917.941.1232 f: +1 212.404.3228