Re: First and Last ID of a table
| From: | Matt Leonhardt | Date: | Wed, 11 Jul 2007 20:30:26 +0000 |
| Subject: | Re: First and Last ID of a table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43772@lists.php.net to get a copy of this message | ||
<tg-php@gryffyndevelopment.com> wrote in message
news:20070711201352.905EE10A008@spaceymail-a2.g.dreamhost.com...
> SELECT MIN(id), MAX(id) FROM mytable
As an aside, is you are using associative arrays, be sure to use the
following keys:
$array['MIN(id)'] and $array['MAX(id)']
Just something I figured out recently :)
Matt