使用PHP从SQL Server获取数据（兴趣对象）

Question

I will get data from mssql. But there is a schema between db and table. So I didn't get any data :/ I first time connecting mssql with Php.

How can I work my requests? Where should I write the schema(dbo).waiting your helps

MY DB

MY REQUEST

<?php
$conn=odbc_connect("DRIVER=SQL Server;SERVER=".$ser.";UID=".$user.";PWD=".$pass.";
DATABASE=".$db.";
Address=".$ser.",1433","","");

echo  "Connection: $conn";

if ($conn <= 0) { echo "Error"; exit; }
else { echo "Success"; };


$kayitlar = odbc_exec($conn,"Select * From LG_001_ITEMS LIMIT 10");

while($kayit = odbc_fetch_array($kayitlar)){

    echo $kayit["NAME"]."<br>";
}
?>

ANSWER

This request solved connection problem and get data array.

$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());
$row=odbc_fetch_array($result);

while ($row) {
    print_r($row);

  }

BUT NOW :(

I can't get data from array. It show "ARRAY=>[]..." . What can I do?

AND SOLVE

$conn=odbc_connect("DRIVER=SQL Server;SERVER=".$ser.";UID=".$user.";PWD=".$pass.";
DATABASE=".$db.";
Address=".$ser.",1433","","");

echo  "Bağlantı: $conn";

if ($conn <= 0) { echo "Başarısız"; exit; }
else { echo "Başarılı"; };

$sql="select * 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());

$row=odbc_exec($conn,$sql);

if(!$row){exit("Hata");}
else{
    echo "<br>++<br>";
while(odbc_fetch_row($row)){
$sonuc=odbc_result($row,"NAME");
    echo $sonuc."<br>";
}


}

THANKS everyone