Are you wanting to do this in one query? You could put an order by on your second query. The first row returned by it should be what you are after.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]