Re: [PHP-DB] getting ID
At 19:19 8/19/2001, CrossWalkCentral wrote the following:
--
>I have a script where I submit user data to the database in my script I need
>to get the id # how can I do this w/o creating a query that does the
>following considering that user could have 10 other entires.
mysql_query("insert into ...");
$id = mysql_insert_id();
>// Request info
>$result = mysql_query(
>"SELECT * FROM supportsys WHERE email = $email");
>if (!$result) {
>echo("Error performing query: " .
>mysql_error() . "");
>exit();
>}
>
>
>I basicly need to get the id$ of the record just entered
>--
>Cross Walk Central
>www.crosswalkcentral.net
>Support Center
>Your Web Hosting Community!
>
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--end of quote--
[EMAIL PROTECTED]
-
And the eyes of them both were opened and they saw that their files
were world readable and writable, so they chmoded 600 their files.
- Book of Installation chapt 3 sec 7
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] getting ID
I tried this and it gave me an error.
Will this
$id = mysql_insert_id();
allow me to pull out the id?
--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!
"Cynic" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> At 19:19 8/19/2001, CrossWalkCentral wrote the following:
> --
> >I have a script where I submit user data to the database in my script I
need
> >to get the id # how can I do this w/o creating a query that does the
> >following considering that user could have 10 other entires.
>
> mysql_query("insert into ...");
> $id = mysql_insert_id();
>
>
> >// Request info
> >$result = mysql_query(
> >"SELECT * FROM supportsys WHERE email = $email");
> >if (!$result) {
> >echo("Error performing query: " .
> >mysql_error() . "");
> >exit();
> >}
> >
> >
> >I basicly need to get the id$ of the record just entered
> >--
> >Cross Walk Central
> >www.crosswalkcentral.net
> >Support Center
> >Your Web Hosting Community!
> >
> >
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> --end of quote--
>
>
> [EMAIL PROTECTED]
> -
> And the eyes of them both were opened and they saw that their files
> were world readable and writable, so they chmoded 600 their files.
> - Book of Installation chapt 3 sec 7
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] getting ID
mysql_insert_id([resource link_identifier]) returns the value of the
auto_increment field for the previous INSERT query. It will return 0 if
there is not an auto_increment field. If the link_identifier is not
specified, the last opened connection is used.
So, use $id = mysql_insert_id(); directly after your $result =
mysql_query($query); operation (where $query is an INSERT query) to pull the
id value you have just auto inserted back out.
Ian.
Manual page: http://www.php.net/manual/en/function.mysql-insert-id.php
Crosswalkcentral <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I tried this and it gave me an error.
>
> Will this
>
> $id = mysql_insert_id();
>
> allow me to pull out the id?
>
>
> --
> Cross Walk Central
> www.crosswalkcentral.net
> Support Center
> Your Web Hosting Community!
>
> "Cynic" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > At 19:19 8/19/2001, CrossWalkCentral wrote the following:
> > --
> > >I have a script where I submit user data to the database in my script I
> need
> > >to get the id # how can I do this w/o creating a query that does the
> > >following considering that user could have 10 other entires.
> >
> > mysql_query("insert into ...");
> > $id = mysql_insert_id();
> >
> >
> > >// Request info
> > >$result = mysql_query(
> > >"SELECT * FROM supportsys WHERE email = $email");
> > >if (!$result) {
> > >echo("Error performing query: " .
> > >mysql_error() . "");
> > >exit();
> > >}
> > >
> > >
> > >I basicly need to get the id$ of the record just entered
> > >--
> > >Cross Walk Central
> > >www.crosswalkcentral.net
> > >Support Center
> > >Your Web Hosting Community!
> > >
> > >
> > >
> > >
> > >--
> > >PHP Database Mailing List (http://www.php.net/)
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > --end of quote--
> >
> >
> > [EMAIL PROTECTED]
> > -
> > And the eyes of them both were opened and they saw that their files
> > were world readable and writable, so they chmoded 600 their files.
> > - Book of Installation chapt 3 sec 7
> >
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] getting ID
Is there a similar function for a Sybase - Database ?
> -Original Message-
> From: Ian Grant [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 20, 2001 12:20
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] getting ID
>
> mysql_insert_id([resource link_identifier]) returns the value of the
> auto_increment field for the previous INSERT query. It will return 0 if
> there is not an auto_increment field. If the link_identifier is not
> specified, the last opened connection is used.
>
> So, use $id = mysql_insert_id(); directly after your $result =
> mysql_query($query); operation (where $query is an INSERT query) to pull
> the
> id value you have just auto inserted back out.
>
>
> Ian.
>
> Manual page: http://www.php.net/manual/en/function.mysql-insert-id.php
> Crosswalkcentral <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I tried this and it gave me an error.
> >
> > Will this
> >
> > $id = mysql_insert_id();
> >
> > allow me to pull out the id?
> >
> >
> > --
> > Cross Walk Central
> > www.crosswalkcentral.net
> > Support Center
> > Your Web Hosting Community!
> >
> > "Cynic" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > At 19:19 8/19/2001, CrossWalkCentral wrote the following:
> > > --
> > > >I have a script where I submit user data to the database in my script
> I
> > need
> > > >to get the id # how can I do this w/o creating a query that does the
> > > >following considering that user could have 10 other entires.
> > >
> > > mysql_query("insert into ...");
> > > $id = mysql_insert_id();
> > >
> > >
> > > >// Request info
> > > >$result = mysql_query(
> > > >"SELECT * FROM supportsys WHERE email = $email");
> > > >if (!$result) {
> > > >echo("Error performing query: " .
> > > >mysql_error() . "");
> > > >exit();
> > > >}
> > > >
> > > >
> > > >I basicly need to get the id$ of the record just entered
> > > >--
> > > >Cross Walk Central
> > > >www.crosswalkcentral.net
> > > >Support Center
> > > >Your Web Hosting Community!
> > > >
> > > >
> > > >
> > > >
> > > >--
> > > >PHP Database Mailing List (http://www.php.net/)
> > > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > >For additional commands, e-mail: [EMAIL PROTECTED]
> > > >To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> > > --end of quote--
> > >
> > >
> > > [EMAIL PROTECTED]
> > > -
> > > And the eyes of them both were opened and they saw that their files
> > > were world readable and writable, so they chmoded 600 their files.
> > > - Book of Installation chapt 3 sec 7
> > >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
If you have received this e-mail in error or wish to read our e-mail disclaimer
statement and monitoring policy, please refer to
http://www.drkw.com/disc/email/ or contact the sender.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] getting ID
With MSSQL I do:
$result=mssql_query("select @@IDENTITY as 'jobNumber'");
$row=mssql_fetch_array($result);
$insertid=$row[jobNumber];
May be similar for sybase.. I understand they have similar origins..
Tony
"Walter,
Marcel" To: 'Ian Grant'
<[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: [PHP-DB] getting ID
08/20/2001
11:22 AM
Is there a similar function for a Sybase - Database ?
> -Original Message-
> From: Ian Grant [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 20, 2001 12:20
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] getting ID
>
> mysql_insert_id([resource link_identifier]) returns the value of the
> auto_increment field for the previous INSERT query. It will return 0 if
> there is not an auto_increment field. If the link_identifier is not
> specified, the last opened connection is used.
>
> So, use $id = mysql_insert_id(); directly after your $result =
> mysql_query($query); operation (where $query is an INSERT query) to pull
> the
> id value you have just auto inserted back out.
>
>
> Ian.
>
> Manual page: http://www.php.net/manual/en/function.mysql-insert-id.php
> Crosswalkcentral <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I tried this and it gave me an error.
> >
> > Will this
> >
> > $id = mysql_insert_id();
> >
> > allow me to pull out the id?
> >
> >
> > --
> > Cross Walk Central
> > www.crosswalkcentral.net
> > Support Center
> > Your Web Hosting Community!
> >
> > "Cynic" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > At 19:19 8/19/2001, CrossWalkCentral wrote the following:
> > > --
> > > >I have a script where I submit user data to the database in my
script
> I
> > need
> > > >to get the id # how can I do this w/o creating a query that does
the
> > > >following considering that user could have 10 other entires.
> > >
> > > mysql_query("insert into ...");
> > > $id = mysql_insert_id();
> > >
> > >
> > > >// Request info
> > > >$result = mysql_query(
> > > >"SELECT * FROM supportsys WHERE email = $email");
> > > >if (!$result) {
> > > >echo("Error performing query: " .
> > > >mysql_error() . "");
> > > >exit();
> > > >}
> > > >
> > > >
> > > >I basicly need to get the id$ of the record just entered
> > > >--
> > > >Cross Walk Central
> > > >www.crosswalkcentral.net
> > > >Support Center
> > > >Your Web Hosting Community!
> > > >
> > > >
> > > >
> > > >
> > > >--
> > > >PHP Database Mailing List (http://www.php.net/)
> > > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > >For additional commands, e-mail: [EMAIL PROTECTED]
> > > >To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> > > --end of quote--
> > >
> > >
> > > [EMAIL PROTECTED]
> > > -
> > > And the eyes of them both were opened and they saw that their files
> > > were world readable and writable, so they chmoded 600 their files.
> > > - Book of Installation chapt 3 sec 7
> > >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED
RE: [PHP-DB] getting ID
Yap ... this works quite fine with Sybase
Thank you very much ...
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 20, 2001 12:27
> To: Walter, Marcel
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] getting ID
>
>
> With MSSQL I do:
>
> $result=mssql_query("select @@IDENTITY as 'jobNumber'");
> $row=mssql_fetch_array($result);
> $insertid=$row[jobNumber];
>
> May be similar for sybase.. I understand they have similar origins..
>
> Tony
>
>
>
>
>
> "Walter,
>
> Marcel" To: 'Ian Grant'
> <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>
> @drkw.com>Subject: RE: [PHP-DB]
> getting ID
>
>
> 08/20/2001
>
> 11:22 AM
>
>
>
>
>
>
>
>
>
> Is there a similar function for a Sybase - Database ?
>
> > -Original Message-
> > From: Ian Grant [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, August 20, 2001 12:20
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] getting ID
> >
> > mysql_insert_id([resource link_identifier]) returns the value of the
> > auto_increment field for the previous INSERT query. It will return 0 if
> > there is not an auto_increment field. If the link_identifier is not
> > specified, the last opened connection is used.
> >
> > So, use $id = mysql_insert_id(); directly after your $result =
> > mysql_query($query); operation (where $query is an INSERT query) to pull
> > the
> > id value you have just auto inserted back out.
> >
> >
> > Ian.
> >
> > Manual page: http://www.php.net/manual/en/function.mysql-insert-id.php
> > Crosswalkcentral <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > I tried this and it gave me an error.
> > >
> > > Will this
> > >
> > > $id = mysql_insert_id();
> > >
> > > allow me to pull out the id?
> > >
> > >
> > > --
> > > Cross Walk Central
> > > www.crosswalkcentral.net
> > > Support Center
> > > Your Web Hosting Community!
> > >
> > > "Cynic" <[EMAIL PROTECTED]> wrote in message
> > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > At 19:19 8/19/2001, CrossWalkCentral wrote the following:
> > > > --
> > > > >I have a script where I submit user data to the database in my
> script
> > I
> > > need
> > > > >to get the id # how can I do this w/o creating a query that does
> the
> > > > >following considering that user could have 10 other entires.
> > > >
> > > > mysql_query("insert into ...");
> > > > $id = mysql_insert_id();
> > > >
> > > >
> > > > >// Request info
> > > > >$result = mysql_query(
> > > > >"SELECT * FROM supportsys WHERE email = $email");
> > > > >if (!$result) {
> > > > >echo("Error performing query: " .
> > > > >mysql_error() . "");
> > > > >exit();
> > > > >}
> > > > >
> > > > >
> > > > >I basicly need to get the id$ of the record just entered
> > > > >--
> > > > >Cross Walk Central
> > > > >www.crosswalkcentral.net
> > > > >Support Center
> > > > >Your Web Hosting Community!
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >--
> > > > >PHP Database Mailing List (http://www.php.net/)
> > > > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > >For additional commands, e-mail: [EMAIL PROTECTED]
> > > > >To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> > > > --end of quote--
> > > >
> > > >
> > > > [EMAIL PROTECTED]
> > > > -
> > > > And the eyes of them both were opened and they saw that their files
> > > > were world readable and writable, so they chmoded 600 their files.
> > > > - Book of Installation chapt 3 sec 7
> > > >
> > >
>
Re: [PHP-DB] getting ID
Just a little addition...
I use this function to get the id value, given a field name, field data and
table name:
function getId($fname,$data,$tblName) {
GLOBAL $conn;
$query = "SELECT id FROM $tblName WHERE $fname = '$data'";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$id = $row[0];
return $id;
}
Ian.
Ian Grant <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> mysql_insert_id([resource link_identifier]) returns the value of the
> auto_increment field for the previous INSERT query. It will return 0 if
> there is not an auto_increment field. If the link_identifier is not
> specified, the last opened connection is used.
>
> So, use $id = mysql_insert_id(); directly after your $result =
> mysql_query($query); operation (where $query is an INSERT query) to pull
the
> id value you have just auto inserted back out.
>
>
> Ian.
>
> Manual page: http://www.php.net/manual/en/function.mysql-insert-id.php
> Crosswalkcentral <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I tried this and it gave me an error.
> >
> > Will this
> >
> > $id = mysql_insert_id();
> >
> > allow me to pull out the id?
> >
> >
> > --
> > Cross Walk Central
> > www.crosswalkcentral.net
> > Support Center
> > Your Web Hosting Community!
> >
> > "Cynic" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > At 19:19 8/19/2001, CrossWalkCentral wrote the following:
> > > --
> > > >I have a script where I submit user data to the database in my script
I
> > need
> > > >to get the id # how can I do this w/o creating a query that does the
> > > >following considering that user could have 10 other entires.
> > >
> > > mysql_query("insert into ...");
> > > $id = mysql_insert_id();
> > >
> > >
> > > >// Request info
> > > >$result = mysql_query(
> > > >"SELECT * FROM supportsys WHERE email = $email");
> > > >if (!$result) {
> > > >echo("Error performing query: " .
> > > >mysql_error() . "");
> > > >exit();
> > > >}
> > > >
> > > >
> > > >I basicly need to get the id$ of the record just entered
> > > >--
> > > >Cross Walk Central
> > > >www.crosswalkcentral.net
> > > >Support Center
> > > >Your Web Hosting Community!
> > > >
> > > >
> > > >
> > > >
> > > >--
> > > >PHP Database Mailing List (http://www.php.net/)
> > > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > >For additional commands, e-mail: [EMAIL PROTECTED]
> > > >To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> > > --end of quote--
> > >
> > >
> > > [EMAIL PROTECTED]
> > > -
> > > And the eyes of them both were opened and they saw that their files
> > > were world readable and writable, so they chmoded 600 their files.
> > > - Book of Installation chapt 3 sec 7
> > >
> >
> >
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
