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@xxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Subject: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
