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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php