Re: Query mysql highest id number
| From: | Bobby Patel | Date: | Sun, 22 Jun 2003 13:58:56 +0000 |
| Subject: | Re: Query mysql highest id number | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-152449@lists.php.net to get a copy of this message | ||
you can you the Mysql MAX function, I believe
Select Max(ID) from Table;
Also, you may want to look at PHP's mysql_insert_id(), (if you are trying to
find the id number after an insert (if that's what you want)).
"Chris Schoeman" <c.schoeman@eudoramail.com> wrote in message
news:1mvafvo5e3cvfg4jdmksrvgodeacfj10lf@4ax.com...
> I want to make a query in a mysql database with as result
> the row with the highest id number. How can I do that?
>
>