How to use db_fetch_object in Drupal 7

$result = db_query_range("SELECT name FROM {users} WHERE LOWER(name) LIKE LOWER('%s%%')", $string, 0, 10); // show first 10
while ($user = db_fetch_object($result)) {
  $matches[$user->name] = check_plain($user->name);
}

 

********************************** ************************* ************************ **************** ****************** *********** ************** ************* ************ *************