// Form:
<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 />";
}
?>