How to display results from $DB->query

[eluser]GlynD[/eluser]
Got it working. Thanks for the input folks. Here's the final code:

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==1){
      echo $query->row['member_id'];
   }
?>