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;
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
-Original Message-
From: Németh Zoltán [mailto:[EMAIL PROTECTED]
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
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
@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
:* 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
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
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
On Friday 23 March 2007 15:45, Dan Shirah wrote:
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;
On Fri, March 23, 2007 9:45 am, Dan Shirah wrote:
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;
On Fri, March 23, 2007 10:07 am, Dan Shirah wrote:
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()
I guarantee that there is a way to do it in MSSQL,
11 matches
Mail list logo