Re: [PHP-DB] MySQL SQL Query Help

[Niel Archer]

Hi 

Try:

SELECT fkid, MAX(foo), bar FROM table GROUP BY fkid ORDER BY bar DESC

Niel

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php