Forum PHP.pl

<form action="search.php" method="post">

<table width="200">
  <tr>
   <td class="c">wyszukaj</td>
  </tr>
  <tr>
   <th>
    <select name="typ">
     <option value="tresc">tresc</option>
     <option value="autor">Autor</option>

    </select>
    &nbsp;&nbsp;
    <input type="text" name="szukany_tekst"/>
    &nbsp;&nbsp;

    <input type="submit" value="Szukaj" />
   </th>
  </tr>
</table>
</form>

<?

include('common.php');

$szukany_tekst = mysql_real_escape_string(addslashes($_POST["szukany_tekst"]));

switch($_POST["typ"]){

case "tresc":{
$search = $db->query("SELECT * FROM newsy WHERE tresc LIKE '%".$szukany_tekst."%' LIMIT 30;");
}
break;

case "autor":{
$search = $db->query("SELECT * FROM newsy WHERE autor LIKE '%".$szukany_tekst."%' LIMIT 30;");
}
break;
}

if(isset($szukany_tekst) && isset($_POST["typ"])){
while($r = mysql_fetch_array($search, MYSQL_BOTH)){

if($_POST['typ'] == 'tresc'){
echo $r['tresc'];
echo '<br>';
}


}
}
?>