<form method="POST" action="ara.php"> 

Search Word: <input type="text" name="sorgu"> 

<input type="SUBMIT" value="ARA!"> 

</form> 



<? 

// ara.php

$sql = mysql_query("SELECT column1, column2 FROM yourtable WHERE column1 LIKE %$sorgu% OR column2 LIKE %$sorgu%") or die (mysql_error()); 



while(list($column1, $column2)=mysql_fetch_array($sql)){ 



echo "Sonuç: $column1, $column2 <br />"; 



} 

?>