Re: Insert and Update on same page

You didn't mention which database you're working with, so I'll assume mysql. In a word, yes, this is possible, just do it in sequence. pseudo-code: mysql_query("insert blah blah"); $id = mysql_insert_id(); $data = mysql_fetch_assoc(mysql_query("select * from table where id = $id")); $uniqueID = (put your code here) mysql_query("update blah blah blah"); // done. On Monday 01 November 2004 12:00 pm, Bomgardner, Mark A wrote: > 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