Здравствуйте!

Есть поиск на сайте (недоделанный) ищет из базы и выводит результат!
Нужно переделать:
- добавить пару критериев поиска
- выдача сомго поиска

Все рааботает с базой!

вот на всякий случай код!Можете предложить свой!



и обработчик

[PHP]<?php
include "dbconfig.php";
if(isset($_POST['search']) && !empty($_POST['search'])) {
$i = 0;
$b = 1;
$bhg = 1;
echo "<table border='0'><tr><td><table>";
while($bhg < 12) {
echo "<tr><td>" . $bhg . "</td></tr>";
$bhg++;
}
echo "</table></td><td>";
$DBH->query("SET NAMES 'utf8'");
$option = $_POST['options'];
$name = $_POST['search'];
$city = $_POST['search'];
$country = $_POST['search'];
$a = explode(" ", $name, $city, $country);
if(count($a) > 1) {
$i = 1;
while($i < count($a)) {
$STH = $DBH->query("SELECT * FROM `chatusers` WHERE `".$option."` LIKE '%".$a[$i]."%'");
$STH->setFetchMode(PDO::FETCH_ASSOC);
while($row = $STH->fetch()) {
if(isset($array) && array_search($row['id'], $array) === false) {
$users = "<table><tr><td><center>[".$b."]</center></td></tr><tr><td>".$row['user']."</td></tr><tr><td>".$row['email']."</td></tr><tr><td>".$row['name']."</td></tr><tr><td>".$row['country']."</td></tr><tr><td>".$row['state']."</td></tr><tr><td>".$row['city']."</td></tr><tr><td>".$row['phone']."</td></tr><tr><td>".$row['adress']."</td></tr><tr><td>".$row['money']."</td></tr><tr><td>".$row['status']."</td></tr><td></table></td><td>";
echo $users; $i = 1; $b++;
$array[] = $row['id'];
} else {
$users = "<table><tr><td><center>[".$b."]</center></td></tr><tr><td>".$row['user']."</td></tr><tr><td>".$row['email']."</td></tr><tr><td>".$row['name']."</td></tr><tr><td>".$row['country']."</td></tr><tr><td>".$row['state']."</td></tr><tr><td>".$row['city']."</td></tr><tr><td>".$row['phone']."</td></tr><tr><td>".$row['adress']."</td></tr><tr><td>".$row['money']."</td></tr><tr><td>".$row['status']."</td></tr><td></table></td><td>";
echo $users; $i = 1; $b++;
$array[] = $row['id'];
}
}
$i++;
}
}
$STH = $DBH->query("SELECT * FROM `chatusers` WHERE `".$option."` LIKE '%".$name."%'");
$STH->setFetchMode(PDO::FETCH_ASSOC);
while($row = $STH->fetch()) {
if(isset($array)) {
if(array_search($row['id'], $array) === false) {
$users = "<table><tr><td><center>[".$b."]</center></td></tr><tr><td>".$row['user']."</td></tr><tr><td>".$row['email']."</td></tr><tr><td>".$row['name']."</td></tr><tr><td>".$row['country']."</td></tr><tr><td>".$row['state']."</td></tr><tr><td>".$row['city']."</td></tr><tr><td>".$row['phone']."</td></tr><tr><td>".$row['adress']."</td></tr><tr><td>".$row['money']."</td></tr><tr><td>".$row['status']."</td></tr><td></table></td><td>";
echo $users; $i = 1; $b++;
}
} else {
$users = "<table><tr><td><center>[".$b."]</center></td></tr><tr><td>".$row['user']."</td></tr><tr><td>".$row['email']."</td></tr><tr><td>".$row['name']."</td></tr><tr><td>".$row['country']."</td></tr><tr><td>".$row['state']."</td></tr><tr><td>".$row['city']."</td></tr><tr><td>".$row['phone']."</td></tr><tr><td>".$row['adress']."</td></tr><tr><td>".$row['money']."</td></tr><tr><td>".$row['status']."</td></tr><td></table></td><td>";
echo $users; $i = 1; $b++;
}
}
echo "</td></tr></table>";
if($i == 0) {
echo "Поиск не дал результатов";
}
}
?>[/PHP]