Re: POST a variable

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() 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 <znemeth@alterationx.hu> 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