Re: Finding the highest number in a column?
| From: | David Robley | Date: | Thu, 28 Oct 2004 03:39:29 +0000 |
| Subject: | Re: Finding the highest number in a column? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37057@lists.php.net to get a copy of this message | ||
On Thu, 28 Oct 2004 13:03, Chris Payne wrote:
> Hi there everyone,
>
>
>
> I am working with a very complex system where not all numbers are assigned
> 1, 2, 3 ?? etc ?? so there could be a row with the number 1 and then the
> next row could be 40 and so on ??
>
>
>
> Is there a way with PHP and MySQL to find out what the highest number is
> in a particular column easily when the numbers are auto-incremented so
> aren?t necessarily one after the other?
>
>
>
> I would really appreciate any help on this as it?s really bugging me.
>
>
>
> Chris
Does SELECT MAX(column) do what you want?
--
David Robley
Me know gammar. Me cood use it gud.