It seems to me @@identity should sufice, and it certainly does not need to
be any 'new' function, since it had been there for quite a while. My
feeling is that those added functions might be used for elaborate stored
procedures, where you might be dealing with multiple tables or some fancy
administrative uses. You certainly DON'T want any function that gives you
the last identity of some other connection!
$get_max = "SELECT @@identity";
$max_result = mssql_query($get_max) or die(mssql_error());
$max_id = mssql_fetch_row($max_result);
echo $max_id[0];
Though the fetch will return only one record with only one field, it will
still return that as an array, even if it only contains one element, so you
still need to add the [0]. Unfortunately, PHP doesn't allow the brackets to
a function that returns an array.
You might use mssql_result instead:
$get_max = "SELECT @@identity";
$max_result = mssql_query($get_max) or die(mssql_error());
$max_id = mssql_result($max_result,0,0);
echo $max_id;
Satyam
----- Original Message -----
From: "Dan Shirah" <[EMAIL PROTECTED]>
To: "Satyam" <[EMAIL PROTECTED]>
Cc: "php-general" <php-general@lists.php.net>
Sent: Friday, March 23, 2007 7:48 PM
Subject: Re: [PHP] POST a variable
Sorry, I was more tailoring my question to the syntax of my query. It
wasn't displaying anything for my echo.
I've changed it to this now:
$get_max = "SELECT scope_identity()";
$max_result = mssql_query($get_max) or die(mssql_error());
$max_id = mssql_fetch_row($max_result);
echo "$max_id";
But all my echo returns is "array" instead of the number.
Below are brief explanations of the different _identity uses you have.
SELECT *@@IDENTITY*
Returns the last IDENTITY value produced on a connection, regardless of the
table that produced the value, and regardless of the scope of the statement
that produced the value.
SELECT *IDENT_CURRENT(*'*tablename*'*)*
This new function returns the last IDENTITY value produced in a table,
regardless of the connection that created the value, and regardless of the
scope of the statement that produced the value.
SELECT *SCOPE_IDENTITY()*
This new function returns the last IDENTITY value produced on a connection
and by a statement in the same scope, regardless of the table that produced
the value.
On 3/23/07, Satyam <[EMAIL PROTECTED]> wrote:
I don't really know about the scope_identity() function, neither much
about @@identity. I know that the names preceded by @@ are MSSQL internal
variables and I think that is the one you are looking for, I just checked
in
the on-line MS documentation, but have no SQL server active at this
moment,
nor have I dealt with one for the last few years, though I did use
auto-increment fields and I certainly was able to retrieve the last id,
somehow. I might be wrong and there might be another function or variable
that gives you the value, but it looks to me @@identity is the one you are
looking for.
There is no need in your code to do any while, if the SQL statement
doesn't fail and triggers the die(), you can rest assured you'll get a
record with a single field, even if it only contains a null, that's the
way
with variables, you can't fail on them, though they might return null.
Satyam
----- Original Message -----
*From:* Dan Shirah <[EMAIL PROTECTED]>
*To:* Satyam <[EMAIL PROTECTED]>
*Sent:* Friday, March 23, 2007 7:14 PM
*Subject:* Re: [PHP] POST a variable
Satyam, I'm trying to retrieve the id using the identity method, but I do
not get anything returned. Do you see anything wrong with this code?
$get_max = "SELECT scope_identity()";
$max_result = mssql_query($get_max) or die(mssql_error());
while($max=mssql_fetch_row($max_result)){
}
$max_id = $max[0];
echo "$max_id";
On 3/23/07, Satyam <[EMAIL PROTECTED]> wrote:
>
> Do a 'select @@identity', it will give you the last record id. The gap
> in
> between steps 3 and 4, brief as it may seem, is enough to get you in
> trouble.
>
> Satyam
>
>
>
> ----- Original Message -----
> From: "Dan Shirah" <[EMAIL PROTECTED]>
> To: "Németh Zoltán" < [EMAIL PROTECTED]>
> Cc: "php-general" <php-general@lists.php.net>
> Sent: Friday, March 23, 2007 4:07 PM
> Subject: Re: [PHP] 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 <[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
> >
> >
>
>
>
>
--------------------------------------------------------------------------------
>
>
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date:
> 22/03/2007
> 7:44
>
>
------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date:
22/03/2007 7:44
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 22/03/2007
7:44
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
