Finding the highest number in a column?
| From: | Chris Payne | Date: | Thu, 28 Oct 2004 03:33:02 +0000 |
| Subject: | Finding the highest number in a column? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37056@lists.php.net to get a copy of this message | ||
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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/2004