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...


From: "Bomgardner, Mark A" <[EMAIL PROTECTED]>
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

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to