tablo isimlerinin düzgün gelmesinin nedeni o kısmın html den elle girilmiş olması
index.php
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-9">
<title>Deneme Logo Rapor</title>
</head>
<body>
<h1>DENEME RAPORU</h1><br>
<form action="" method="post">
<input type="submit">
</form><br><br>
<table border="1" align="center">
<tr >
<td width="3%">Ambar No</td>
<td width="5%">Stok Kodu</td>
<td width="5%">Açıklama</td>
<td width="5%">Stok Miktarı</td>
<td width="2%">Birim</td>
<td width="10%">Statü</td>
</tr>
<?php
$toplam = 0;
include_once("baglan.php");
$sorgu = odbc_exec($baglan, "SELECT LOGICALREF, NAME, CODE, ACTIVE FROM LG_001_ITEMS");
while( $veri=odbc_fetch_array($sorgu) ){
// print_r($veri);
$sorgu2 = odbc_exec($baglan, "SELECT STOCKREF, INVENNO, ONHAND FROM LV_001_01_STINVTOT WHERE STOCKREF=".$veri['LOGICALREF']);
$veri2 = odbc_fetch_array($sorgu2);
$sorgu3 = odbc_exec($baglan, "SELECT STOCKREF, ONHAND FROM LV_001_01_STINVTOT WHERE STOCKREF=".$veri['LOGICALREF']);
$veri3=odbc_fetch_array($sorgu3);
//print_r($veri3);
$sorgu4 = odbc_exec($baglan, "SELECT UNITSETREF FROM LG_001_ITEMS WHERE LOGICALREF=".$veri['LOGICALREF']);
$veri4=odbc_fetch_array($sorgu4);
?>
<tr >
<td width="3%"><?php echo $veri2['INVENNO']; ?></td>
<td width="5%"><?php echo $veri['CODE']; ?></td>
<td width="5%"><?php echo $veri['NAME']; ?></td>
<td width="5%"><?php echo $toplam; ?></td>
<td width="2%"><?php if($veri4['UNITSETREF'] == 5){ $birim = "Adet"; }else { $birim=""; } echo $birim; ?></td>
<td width="10%"><?php if($veri['ACTIVE'] == 0){ $durum = "Kullanımda"; }else { $durum="Kullanım Dışı";} echo $durum; ?></td>
</tr><?php } odbc_close($baglan);?>
</body>
</html>baglan.php<?php
$server = "FEYYAZ";
$database = "GO3";
$user = "sa";
$password = "logo";
$baglan = odbc_connect( "Driver={SQL Server};Server=$server;Database=$database;", $user, $password);
if($baglan <= 0){
echo "bağlantı başarısız";
exit;
}else{
echo "bağlantı başarılı";
}
?> 