]]
Sent: Friday, December 06, 2002 1:52 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: NewB: Return New Record ID...
Try $last=mysql_insert_id();
Jochem
Doug Coning wrote:
Hi all,
How do I do this:
I need a PHP page that simply creates a blank record so that I have the
record's ID (which
11 4316 5754
Fax: 54 11 4316 5734
[EMAIL PROTECTED]
-Original Message-
From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 2:06 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: NewB: Return New Record ID...
for MS SQL and Oracle does anyone know
KPMG Argentina
Tel: 54 11 4316 5754
Fax: 54 11 4316 5734
[EMAIL PROTECTED]
-Original Message-
From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 2:06 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: NewB: Return New Record ID...
for MS SQL and Oracle
Message-
From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 2:36 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: NewB: Return New Record ID...
This doesn't work as expected through ODBC... it does not seem to return any
value...
Ryan
-Original
. it looks like I'll have to take my chances with select max()
Ryan
-Original Message-
From: Bernain, Fernando G. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 26, 2002 10:43 AM
To: Ryan Jameson (USA)
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: NewB: Return New Record ID...
You
PROTECTED]]
Sent: Thursday, December 26, 2002 2:46 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: NewB: Return New Record ID...
The problem is I have hundreds of tables each with a different column list
and syntax, I don't want to have to create a SP for each table. There really
has
PROTECTED]]
Sent: Thursday, December 26, 2002 10:54 AM
To: Ryan Jameson (USA)
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: NewB: Return New Record ID...
It's not a bad idea to encapsulate de querys (selects, updates, inserts,...)
in SPs...
Good luck with the select max()!!!
PD: If you dont
Try $last=mysql_insert_id();
Jochem
Doug Coning wrote:
Hi all,
How do I do this:
I need a PHP page that simply creates a blank record so that I have the
record's ID (which is automatically generated). That same page then needs
to return the record ID back so that I know what the ID is. I