Re: [PHP] POST a variable

2007-03-23 Thread Richard Lynch
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

Re: [PHP] POST a variable

2007-03-23 Thread Richard Lynch
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"; > $ma

Re: [PHP] POST a variable

2007-03-23 Thread Børge Holen
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"; > $max_r

Re: [PHP] POST a variable

2007-03-23 Thread Dan Shirah
: "Dan Shirah" <[EMAIL PROTECTED]> To: "Satyam" <[EMAIL PROTECTED]> Cc: "php-general" 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 disp

Re: [PHP] POST a variable

2007-03-23 Thread Satyam
TED]> Cc: "php-general" 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_id

Re: [PHP] POST a variable

2007-03-23 Thread Dan Shirah
iginal 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

Re: [PHP] POST a variable

2007-03-23 Thread Satyam
<[EMAIL PROTECTED]> Cc: "php-general" 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 sam

Re: [PHP] POST a variable

2007-03-23 Thread Németh Zoltán
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

RE: [PHP] POST a variable

2007-03-23 Thread Edward Kay
> -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

Re: [PHP] POST a variable

2007-03-23 Thread Dan Shirah
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 ente

Re: [PHP] POST a variable

2007-03-23 Thread Németh Zoltán
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_req