2007. 03. 23, péntek keltezéssel 11.07-kor Dan Shirah ezt írta: > The reason I have to use it as I posted is because I am using > Microsoft SQL server instead of MySQL. And I haven't found a php > function for MSSQL that works the same as mysql_insert_id()
you wrote something earlier as far as I can remember about a MSSQL function scope_identity() which returns the last inserted id why not use that? greets Zoltán Németh > > So, to come out with a comparable function with pretty reliable > results, I follow this process: > > 1. User enters data into form > 2. User submits form > 3. Save page inserts info into the database > 4. Directly after the insert statement is my SELECT MAX query > 5. I assign the retrieved value to a hidden field > 6. I pass this value to the next form > > I figure the odds of another record being inserted inbetween the time > it takes to go from step 3 to step 4 are very, very minimal. We're > talking about MAYBE a 2-3 millisecond gap? > > > On 3/23/07, Németh Zoltán <[EMAIL PROTECTED]> wrote: > 2007. 03. 23, péntek keltezéssel 10.45-kor Dan Shirah ezt > írta: > > Okay, I feel like the correct answer to this is about 2mm > back in my grey > > matter. > > > > 1. I have a query that pulls the last row number when a > newly inserted > > record is added: > > > > $maximum="SELECT MAX(payment_id) FROM payment_request"; > > $max_result=mssql_query($maximum); > > while($max=mssql_fetch_row($max_result)){ > > } > > $max_id = $max[0]; > > > > 2. I have multiple selections for the user to pick, but > regardless of what > > they choose I want the $max_id variable to be passed to the > next page. > > > > 3. Would I go about this by assigning $max_id to a hidden > field like below? > > > > <input type="hidden" value="<?php echo "$max_id"; ?>" > size="5" > > maxlength="10" name="max_id" /> > > > > 4. And then to retrieve this value on my next page just get > it out of > > $_POST['max_id'] ?? > > > > Does that all sound correct? > > basically yes > but if you want the id of the row you just inserted, using > mysql_insert_id() is better because if another insert is > happening at > the same time, select max() may give you incorrect result > > greets > Zoltán Németh > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php