Я написал маленкий мод словар все хорошо работаю только одного поиск словь не работает мне нужно ваши помощ помогите
<?php
/**
* @package JohnCMS
* @link http://johncms.com
* @copyright Copyright (C) 2008-2011 JohnCMS Community
* @license LICENSE.txt (see attached file)
* @version VERSION.txt (see attached file)
* @author http://johncms.com/about
*/
define('_IN_JOHNCMS', 1);
require('../incfiles/core.php');
$textl = 'Lug\'at - Qidiruv';
require('../incfiles/head.php');
/*
-----------------------------------------------------------------
Ma`lumotlarni qidiruv formasida qabul qilamiz
-----------------------------------------------------------------
*/
$search_post = isset($_POST['search']) ? trim($_POST['search']) : false;
$search_get = isset($_GET['search']) ? rawurldecode(trim($_GET['search'])) : '';
$search = $search_post ? $search_post : $search_get;
echo '<div class="phdr"><a href="index.php"><b>Lug\'at</b></a> | Qidiruv oynasi</div>' .
'<form action="search.php" method="post">' .
'So\'zni kiriting<br/>'.
'<div class="gmenu"><p>' .
'<input type="text" name="search" value="' . functions::checkout($search) . '" />' .
'<input type="submit" value="Qidir" name="submit" />' .
'</p></div></form>';
/*
-----------------------------------------------------------------
Xatolarni tekshiramiz
-----------------------------------------------------------------
*/
$error = array();
if (!empty($search) && (mb_strlen($search) < 2 || mb_strlen($search) > 66))
$error[] = 'Taqiqlangan uzunlik!';
/*
if (preg_match("/[^1-9a-z\-\@\*\(\)\?\!\~\_\=\[\]]+/", functions::rus_lat(mb_strtolower($search))))
$error[] = 'Taqiqlangan belgilar!';
*/
if ($search && !$error) {
/*
-----------------------------------------------------------------
Qidiruv natijalarini chiqarish
-----------------------------------------------------------------
$search_db = functions::rus_lat(mb_strtolower($search));
$search_db = strtr($search_db, array (
'_' => '\\_',
'%' => '\\%'
));
*/
$search_db = '%' . $search_db . '%';
$total = mysql_result(mysql_query("SELECT COUNT(*)FROM `lugat` WHERE `eng` AND `uzb` LIKE '" . $search_db . "'"), 0);
echo '<div class="phdr"><b>Qidiruv natijalari</b></div>';
echo '<table class="simple-little-table" cellspacing="0" width="80%"><tr><center><th width="10">N</th></center><th width="45%">Inglizcha</th><th width="45%">O\'zbekchada</th>';
echo '</tr>';
if ($total > 0) {
$req = mysql_query("SELECT * FROM `lugat` WHERE `eng` AND `uzb` LIKE '" . $search_db . "' ORDER BY BINARY (`eng`) LIMIT $start, $kmess");
$i = 0;
$n=$start;
while ($res = mysql_fetch_assoc($req)) {
$n=$n+1;
echo '<tr><td><center>'.$n.'</center></td>';
echo '<td><center>'.$res['eng'].'</center></td>';
echo '<td><center>'.$res['uzb'].'</center></td>';
}
echo '</tr></table>';
}
} else {
echo '<div class="menu"><p>Afsus<br/>Hech nima topilmadi.</p></div>';
}
echo '<div class="phdr">Topildi: ' . $total . ' ta so\'z</div>';
if ($total > $kmess) {
echo '<div class="topmenu">' . functions::display_pagination('search.php?search=' . urlencode($search) . '&', $start, $total, $kmess) . '</div>';
} else {
if ($error)echo functions::display_error($error);
}
echo '<p>' . ($search && !$error ? '<a href="search.php">Yangi qidiruv</a><br />' : '') .
'<a href="index.php">Orqaga</a></p>';
require('../incfiles/end.php');
?>