Finding primary key of record after INSERT

[Gabriel Harrison]

Hi,

I have a mysql db with with autoincrementing primary keys in each table. I
want to allow a user to add a record using a php webpage. Once the page is
added how can I re SELECT that record (for the user to verify) if I don't
know what the primary key was when it was inserted?

Is the only way to not use autoincrement and choose the primary key value
myself?

Thanks

--
Gabriel Harrison
1 Hawthorn Crescent
Durham
DH1 1ED
Telephone: [phone]
Mobile: [phone]

[swdev1]

Gabriel - if your connection to your mysql db is persistent - you should be
able to call the
LAST_INSERT_ID
function ..
and it will return the PK of the row just inserted.
see here for more info:
http://www.mysql.com/doc/en/Miscella...functions.html

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Gabriel Harrison" <Ga*****@gabrielharrison.co.uk> wrote in message
news:bj**********@news6.svr.pol.co.uk...

Hi,

I have a mysql db with with autoincrementing primary keys in each table. I
want to allow a user to add a record using a php webpage. Once the page is
added how can I re SELECT that record (for the user to verify) if I don't
know what the primary key was when it was inserted?

Is the only way to not use autoincrement and choose the primary key value
myself?

Thanks

--
Gabriel Harrison
1 Hawthorn Crescent
Durham
DH1 1ED
Telephone: [phone]
Mobile: [phone]

[swdev1]

Gabriel - if your connection to your mysql db is persistent - you should be
able to call the
LAST_INSERT_ID
function ..
and it will return the PK of the row just inserted.
see here for more info:
http://www.mysql.com/doc/en/Miscella...functions.html

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Gabriel Harrison" <Ga*****@gabrielharrison.co.uk> wrote in message
news:bj**********@news6.svr.pol.co.uk...

Hi,

I have a mysql db with with autoincrementing primary keys in each table. I
want to allow a user to add a record using a php webpage. Once the page is
added how can I re SELECT that record (for the user to verify) if I don't
know what the primary key was when it was inserted?

Is the only way to not use autoincrement and choose the primary key value
myself?

Thanks

--
Gabriel Harrison
1 Hawthorn Crescent
Durham
DH1 1ED
Telephone: [phone]
Mobile: [phone]

[swdev1]

Gabriel - if your connection to your mysql db is persistent - you should be
able to call the
LAST_INSERT_ID
function ..
and it will return the PK of the row just inserted.
see here for more info:
http://www.mysql.com/doc/en/Miscella...functions.html

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Gabriel Harrison" <Ga*****@gabrielharrison.co.uk> wrote in message
news:bj**********@news6.svr.pol.co.uk...

Hi,

I have a mysql db with with autoincrementing primary keys in each table. I
want to allow a user to add a record using a php webpage. Once the page is
added how can I re SELECT that record (for the user to verify) if I don't
know what the primary key was when it was inserted?

Is the only way to not use autoincrement and choose the primary key value
myself?

Thanks

--
Gabriel Harrison
1 Hawthorn Crescent
Durham
DH1 1ED
Telephone: [phone]
Mobile: [phone]

[Ray]

"Gabriel Harrison" <Ga*****@gabrielharrison.co.uk> wrote in message news:<bj**********@news6.svr.pol.co.uk>...

Hi,

I have a mysql db with with autoincrementing primary keys in each table. I
want to allow a user to add a record using a php webpage. Once the page is
added how can I re SELECT that record (for the user to verify) if I don't
know what the primary key was when it was inserted?

Is the only way to not use autoincrement and choose the primary key value
myself?

Thanks

There is a LAST_INSERT_ID function that does this, though I don't use
it as apparently you can point it to a specific table (at least in the
documentation examples). So I do this by doing something like:
SELECT MAX(ID) AS ID FROM table WHERE addedby = 'me'
with the WHERE clause filtering on a field value that was just
inserted so that I can be sure it is looking at only the records that
I added myself.

[Ray]

"Gabriel Harrison" <Ga*****@gabrielharrison.co.uk> wrote in message news:<bj**********@news6.svr.pol.co.uk>...

Hi,

I have a mysql db with with autoincrementing primary keys in each table. I
want to allow a user to add a record using a php webpage. Once the page is
added how can I re SELECT that record (for the user to verify) if I don't
know what the primary key was when it was inserted?

Is the only way to not use autoincrement and choose the primary key value
myself?

Thanks

There is a LAST_INSERT_ID function that does this, though I don't use
it as apparently you can point it to a specific table (at least in the
documentation examples). So I do this by doing something like:
SELECT MAX(ID) AS ID FROM table WHERE addedby = 'me'
with the WHERE clause filtering on a field value that was just
inserted so that I can be sure it is looking at only the records that
I added myself.

[Ray]

"Gabriel Harrison" <Ga*****@gabrielharrison.co.uk> wrote in message news:<bj**********@news6.svr.pol.co.uk>...

Hi,

I have a mysql db with with autoincrementing primary keys in each table. I
want to allow a user to add a record using a php webpage. Once the page is
added how can I re SELECT that record (for the user to verify) if I don't
know what the primary key was when it was inserted?

Is the only way to not use autoincrement and choose the primary key value
myself?

Thanks

There is a LAST_INSERT_ID function that does this, though I don't use
it as apparently you can point it to a specific table (at least in the
documentation examples). So I do this by doing something like:
SELECT MAX(ID) AS ID FROM table WHERE addedby = 'me'
with the WHERE clause filtering on a field value that was just
inserted so that I can be sure it is looking at only the records that
I added myself.