Simple fast way to grab the highest ID from a MySQL table?

[Robert Oschler]

I have a MySQL table on my web server (external web host) that has an
auto-increment integer as it's primary key field.

Is there a quick PHP function that will get me the highest ID in the table,
that is, the ID that belongs to the last record added.

Note, I need it to work across and between connection session, not from
within the same connection session.

thx

--

Robert Oschler
"Let the web hear you, add your voice to your web site in minutes!"
-- http://audiodirect.spiderchase.com/
(For a limited time, free voiceover with every sign-up, use this link
instead)
-- http://audio.spiderchase.com/
(A song - are you blue?)
-- http://bluedreams.spiderchase.com/

[BDR]

~Select uniqueid from table order by uniqueid DESC~

Just run the query once and it'll give you the highest record if you
substitute `uniqueid` and `table` with the correct values. Afaik,
there's no function for php that maintains state variables of database
fields, (unless you write one).

Robert Oschler wrote:

I have a MySQL table on my web server (external web host) that has an
auto-increment integer as it's primary key field.

Is there a quick PHP function that will get me the highest ID in the table,
that is, the ID that belongs to the last record added.

Note, I need it to work across and between connection session, not from
within the same connection session.

[BDR]

~Select uniqueid from table order by uniqueid DESC~

Just run the query once and it'll give you the highest record if you
substitute `uniqueid` and `table` with the correct values. Afaik,
there's no function for php that maintains state variables of database
fields, (unless you write one).

Robert Oschler wrote:

I have a MySQL table on my web server (external web host) that has an
auto-increment integer as it's primary key field.

Is there a quick PHP function that will get me the highest ID in the table,
that is, the ID that belongs to the last record added.

Note, I need it to work across and between connection session, not from
within the same connection session.

[Brandon]

Do a search for "Select Last_Insert_ID()" in the manuals.

That will retrieve the last ID in an auto_increment field.

"Robert Oschler" <no_replies@fake_email_address.invalid> wrote in message
news:wJ******************@news2.news.adelphia.net. ..

I have a MySQL table on my web server (external web host) that has an
auto-increment integer as it's primary key field.

Is there a quick PHP function that will get me the highest ID in the table, that is, the ID that belongs to the last record added.

Note, I need it to work across and between connection session, not from
within the same connection session.

thx

--

Robert Oschler
"Let the web hear you, add your voice to your web site in minutes!"
-- http://audiodirect.spiderchase.com/
(For a limited time, free voiceover with every sign-up, use this link
instead)
-- http://audio.spiderchase.com/
(A song - are you blue?)
-- http://bluedreams.spiderchase.com/

[Brandon]

Do a search for "Select Last_Insert_ID()" in the manuals.

That will retrieve the last ID in an auto_increment field.

"Robert Oschler" <no_replies@fake_email_address.invalid> wrote in message
news:wJ******************@news2.news.adelphia.net. ..

I have a MySQL table on my web server (external web host) that has an
auto-increment integer as it's primary key field.

Is there a quick PHP function that will get me the highest ID in the table, that is, the ID that belongs to the last record added.

Note, I need it to work across and between connection session, not from
within the same connection session.

thx

--

Robert Oschler
"Let the web hear you, add your voice to your web site in minutes!"
-- http://audiodirect.spiderchase.com/
(For a limited time, free voiceover with every sign-up, use this link
instead)
-- http://audio.spiderchase.com/
(A song - are you blue?)
-- http://bluedreams.spiderchase.com/