RE: [PHP-DB] Insert and Update on same page

Sure, the easiest way is to get that unique value with PHP and then insert it, then you can show the form again with that unique value, no need to do an update or other manipulation, if I understand your requirements correctly... Bastien

From: "Bomgardner, Mark A" <mbomgardner@kletc.org> To: <php-db@lists.php.net> Subject: [PHP-DB] Insert and Update on same page Date: Mon, 1 Nov 2004 14:00:29 -0600 I've got a problem with trying to insert and updating on the same page. Here is my problem: I have a form that the user fills out. Upon submission, I want the information that was just inserted, to be pulled back out and shows to the user with an unique number for that record other than the record ID field. I can use the ID field together with another value to get the unique number that I want, but it would require a insert, select and update in one shot. Is this possible? I hope I have not confused everybody Mark A. Bomgardner Technology Specialist KLETC