Как сделать поиск?

<?php
define('_IN_JOHNCMS', 1);
$textl='Поиск'; require_once("../incfiles/core.php");
require_once("poi.php"); require_once("../incfiles/head.php");

$error = false;
$search = isset($_GET['text']) ? trim($_GET['text']) : '';

if ($search && (mb_strlen($search) < 3 || mb_strlen($search) > 20)){
  echo '<div>Разрешено минимум 3 и максимум 20 символов!</div>';
  $error = true;
}
echo '<form action="" method="get"><input type="text" name="text" value="'.$search.'" /><button>Поиск<button/></form>';
if ($search && !$error){
  $sql = strtr($search, array('_' => '\\_', '%' => '\\%', '*' => '%'));
  $query = mysql_query("SELECT * FROM `fman_players` WHERE `name` LIKE '".mysql_real_escape_string($sql)."' ");
  if (mysql_num_rows($query)){
    while ($result = mysql_fetch_assoc($query)){
      echo '<div>'.$result['field'].'</div>';
    }
  }else{
    echo '<div>Пусто</div>';
  }
}
require_once("../incfiles/end.php"); ?>