Помощ за един скрипт за search

[macmen]

Здравейте,
някой може ли да ми каже как мога да направя търсачка да търси по категорий аз се опитвам но някъде греша

това ми е скрипта

echo'<center><form action="download.php" method="post">
<input type="text" name="search" size="35" />';
echo "<select name='catid'>";
echo "<option value=''>ALL</option>";
$cat =  mysql_query("SELECT * FROM categories WHERE id")or die(mysql_error());
while($cat_r = mysql_fetch_object($cat)){
echo "<option value='".$cat_r->id."'>".$cat_r->name."</option>";
}
echo "</select>"; 
echo'<input type="submit" value="Търси" name="submit" />
</form></center>';

echo'<table width="97%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="top">';
//$ns - номер страница
//$br - брой страница
//$one - първа
//$sl - следваща
//$pl - последна
//$pr - предишна
$br = 15;
$pageNum = 1;
if(isset($_GET['page'])) {
$pageNum = $_GET['page'];
}
if($_POST['search']) {
$search = htmlspecialchars(mysql_real_escape_string(addslashes($_POST['search'])));
$redove = ($pageNum - 1) * $br;
$query = "SELECT * FROM download WHERE zaglavie LIKE '%$search%' OR catid LIKE '%$search%' "." LIMIT $redove, $br";
$result = mysql_query($query) or die('Не си избрал страница!');
while($row = mysql_fetch_array($result)) {

echo ('
<table border="1" width="100%" style="border: 1px solid #c0c0c0;border-collapse:collapse;" align="center">
<tr><td align="center"><b>Категория</b></td><td align="center"><b>Заглавие</b></td><td align="center"><b>Файлове</b></td><td align="center"><b>Изтегли</b></td></tr>
<tr>
<td>'.$row['catid'].'</td>
<td align="center"><a href="mailto:'.$row['email'].'"><img src="images/icon_email.gif" border="0"></a></td>
<td align="center"><a rel="nofollow" href="skype:'.$row['skype'].'?userinfo" ><img width=16 height=16 src="http://mystatus.skype.com/smallicon/'.$row['skype'].'" alt="Skype" title="Skype" border="0" /> '.$row['skype'].'</a></td>
<td align="center"><a href="sendpm.php?id='.$row['id'].'"><img src="images/icon_pm.gif" border="0"></a></td>
');
}}
echo ("</tr>
</table>
<br /><center>");
$query = "SELECT COUNT(id) AS numrows FROM download";
$result = mysql_query($query) or die('Не си избрал страница!');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$br);
$self = $_SERVER['PHP_SELF'];
$ns = '';
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$ns .= " $page ";
}
else {
$ns .= " <a href=\"$self?page=$page\">$page</a> ";
}}
if ($pageNum > 1) {
$page = $pageNum - 1;
$pr = " <a href=\"$self?page=$page\"> [<] </a> ";
$one = " <a href=\"$self?page=1\">[първа]</a> ";
}
else {
$pr = ' ';
$one = ' ';
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$sl = (" <a href=\"$self?page=$page\"> [>] </a> ");
$pl = (" <a href=\"$self?page=$maxPage\">[последна]</a> ");
}
else {
$sl = '';
$pl = '';
}
echo $one . $pr . $ns . $sl . $pl;
echo ('
</center></td>
</tr>
</table>


</center>