Cacher is the code snippet organizer for pro developers

<?php
  global $DB;
  $dbRes = $DB->Query('SELECT * FROM `b_sale_order` WHERE ID = ' . $id);

  $aRows = array();
  while ($row = $dbRes->Fetch())
  {
     $aRows[] =  $row;
  }

  echo $aRows[0]["field_name"];