Search Query don't show results
I have a search engine but the problem is the search engine don't show
search results, the connections to the database are correct here is the
code:
PHP :
if (isset($_POST['search'])) {
$searchq = $_POST['search'];
$searchq = preg_replace("#[^0-9a-z]#i", "", $searchq);
$query = mysql_query("SELECT * FROM tReference WHERE sReference LIKE
'%$searchq%' OR sSearch LIKE '%$searchq%' OR sSort LIKE '%$searchq%'") or
die("La Recherche est impossible");
$count = mysql_num_rows($query);
if ($count == 0) {
$output = "Aucun Résultat Pour Cette Recherche!";
//English Trans : No results have been Found!
}
else
{
$sReference = $count['sReference'];
$output.= '<div><ul><li><a target="_blanc"
href="refrences.php?reference=' . $sReference . '" title="' .
$sReference . '">' . $sReference . '</a></li></ul></div>';
}
}
HTML:
<div id="searchd">
<div class="searchc">
<form action="reference.php" method="post">
<input type="text" name="search" palceholder="Recherhcer...">
<input type="submit" Value="Ok">
<div class="clear"></div>
</form>
</div>
<div id="output">
<?php echo ($output); ?>
</div>
</div>
And Thanks to All in advance!