<?php // PHP Code Larımıza Başladık 
mysql_connect("localhost","xxxxxxx","xxxxxxx"); 
mysql_select_db("xxxxxxx"); 
$aranacak_kelime = mysql_real_escape_string($_GET['aranacak_kelime']); /* Aranacak Kelimeyı arama.php den cektik */ 
$sec =$_GET['sec']; /*Selectte nereyı sectıyse ona gore arama komutunu sectık */ 
if($sec=="adi"){ 
$sql= mysql_query("SELECT * FROM deneme WHERE Ad like '%".$aranacak_kelime."%'"); 
}elseif($sec=="soyadi"){ 
$sql= mysql_query("SELECT * FROM deneme WHERE Soyad like '%".$aranacak_kelime."%'"); 
}elseif($sec=="sinif"){ 
$sql= mysql_query("SELECT * FROM deneme WHERE SinifNo like '%".$aranacak_kelime."%'"); 
}elseif($sec=="hepsinde"){ 
$sql= mysql_query("SELECT * FROM deneme WHERE Ad like '%".$aranacak_kelime."%' or Soyad like '%".$aranacak_kelime."%' or SinifNo like '%".$aranacak_kelime."%'"); 
}
?>
<table>
<th width="69" scope="col"> Numarası </th>
    <th width="75" scope="col">Sınıf No </th>
    <th width="116" scope="col"> Adı </th>
    <th width="131" scope="col">Soyadı</th>
    <th width="100" scope="col">Telefon No </th>
    <th width="114" scope="col">Mobil No </th>
    <th width="109" scope="col">Anne Mobil </th>
    <th width="109" scope="col">Baba Mobil </th>

<?
while($row = mysql_fetch_assoc($sql)) {?>

<tr>
    <td><?=$row['numara'];?></td>
    <td><?=$row['sinifno'];?></td>
    <td><?=$row['ad'];?></td>
    <td><?=$row['soyad'];?></td>
    <td><?=$row['tel'];?></td>
    <td><?=$row['mobil'];?></td>
    <td><?=$row['anne'];?></td>
    <td><?=$row['baba'];?></td>
  </tr>
<? }?>
</table>