You cannot mix grouping columns without a group by clause. This would work:
SELECT * FROM MYTABLE order by ifield desc limit 1 Elna Moorhouse wrote:
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
