$sql="select dbo.LG_001_ITEMS.NAME from dbo.LG_001_ITEMS ORDER BY LOGICALREF OFFSET 0 ROWS FETCH FIRST 10 ROWS ONLY";
$result=odbc_exec($conn, $sql) or die (odbc_errormsg());


while ($row=odbc_fetch_array($result)) {
    print_r($row);

  }