TRY: SELECT id,Max(ifield) from MYTABLE. What I don't understand is why you specify id=$id in the where clause. If you already specify the id as let say 1 then the max for that id will be 100 from your example below.
"Richard Fox" <[EMAIL PROTECTED]> wrote in message 003901c2b034$0c563740$0700a8c0@mygroup">news:003901c2b034$0c563740$0700a8c0@mygroup... Hi, What would be a query to select a single record from a number of records in a table, depending on which one has the biggest value in an integer field? e.g something like: MYTABLE ------------ id ifield 1 100 2 200 3 150 SELECT * FROM MYTABLE WHERE id=$id and MAX(ifield) should return id=2, ifield=200 (but this doesn't work, of course) Many thanks, Richard -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
