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 <znemeth@xxxxxxxxxxxxxx> 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
