<?php

$sql = mysql_query('SELECT * FROM oteller order by id desc LIMIT 0 , 30');

$a = 1;
while ($row = mysql_fetch_array($sql)){
$kat = mysql_fetch_array(mysql_query('select *from otelkat4 where id ='.$row['kat4id'].''));

echo '<tr class="tab_satir">'.'<th class="tab_kat" scope="col">'. $a .'</th>
<th class="tab_kat" scope="col"><img src="https://www.r10.net/resimler/oteller/'. $row['resim1k'] .'" width="50" height="50" /></th>
<th class="tab_kat" scope="col">' . $row['baslik'] . '</th>
<th class="tab_kat" scope="col">'. $row['aciklama'] . '</th>
<th class="tab_kat" scope="col">'.$kat['baslik'].'</th>
<th class="tab_kat" scope="col">'. $row['start'].' --- '. $row['end'].'</th>
<th class="tab_kat" scope="col">'.'<a href="?olay=duzenle&id='.$row['id'].'"> <img src="kategori_icon/duzenle.png" /></a>' .'</th>
<th class="tab_kat" scope="col">'.'<a href="?olay=sil&id='.$row['id'].'"> <img src="kategori_icon/sil.png" /></a></th></tr>';

$a++;
}
?>