How do I figure out(using query) who is the richest person?

[mli]

In my db field5 under userfield holds the person's money. How do I set a variable to the user who has the highest value in field5?

[filburt1]

PHP Code:

$user = $DB_site->query_first("SELECT u.userid, u.username, uf.field5
FROM user u, userfield uf
WHERE u.userid = uf.userid ORDER BY uf.field1 DESC LIMIT 1"); 

Then in templates, use $user[userid], $user[username], and $user[field5].