Hi
I show you a sample.
<?
///your site user name and pass
$user="xxxx";
$pass="xxxx";$host="localhost";
$dba = mysql_connect($host, $user ,$pass);
if (!$dba)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
};
mysql_select_db(torkiye_html);
$txt=$_POST["search"];
$txt=addslashes($txt);
$sa="like "."'%".$txt."%'";
// your tables structures
$query = "select * from databsetablename where fieldname1".$sa." or fieldname2".$sa;
//resualts
$resultsearch = mysql_query($query);
// counting the found records number
$aramasayisi= mysql_num_rows($resultsearch);
// print the search case
echo "Search for <b>".$txt."</b>";
// if records find or not
if($aramasayisi>0){echo '<p dir="rtl" align="justify">'.$aramasayisi;echo ' found';}else{ echo '<p dir="rtl" align="justify">no record found';};
echo '<p dir="rtl" align="justify">';
// listing the results and show them in PHP
for($r=0;$r<$aramasayisi;$r++){
$row = mysql_fetch_array($resultsearch);
echo $r+1;
echo " - ";
echo '<a href="/'.$row["urls_form_table"].'">'.$row["fieldname1"].'</a>';
echo '<br>'.$row["fieldname2"].'<br>';
};
?>
you can my site that if fully mysql based at
http://www.torkiye.com