How to display results from $DB->query

[eluser]GlynD[/eluser]
Hi all

I'm using this query to get the last member_id from the table exp_members:

Code:

<?php
   global $DB;
   $query = $DB->query("SELECT member_id FROM exp_members ORDER BY member_id DESC LIMIT 0, 1");
   if ($query->num_rows > 0){
      echo $query->row(...);
   }
?>

But I've not been able to work out how to get the member_id from the query. Any suggestions welcome.

Many thanks

Glyn