|
| | ';
echo "";
if ($_POST[search]!="")
{
$search_query="select * from ta4ka_partners where id>0 and show_=1 ".
((trim($partner_name)!="")?" and name like '%$partner_name%'":"").
(($_POST[vendor]!=-1)?" and (".
($_POST[vendor]!=-1?"cars1_id=$_POST[vendor]":"cars1_id!=''").
" or ".
($_POST[vendor]!=-1?"cars2_id=$_POST[vendor]":"cars2_id!=''").
" or ".
($_POST[vendor]!=-1?"cars3_id=$_POST[vendor]":"cars3_id!=''").
")":"").
(($city!=-1)?" and city_id=$city":"").
(($_POST[metro]!=-1)?" and metro_id=$_POST[metro]":"").
(($_POST[parts]==1)?" and act_parts=1":"").
(($_POST[service]==1)?" and act_service=1":"").
(($_POST[moving]==1)?" and act_moving=1":"").
(($_POST[cars]==1)?" and act_cars=1":"").
(($_POST[crashed]==1)?" and act_crashed=1":"")
;
// echo "[$search_query]";
$partners=mysql_query($search_query);
$t_partners=@mysql_num_rows($partners);
if ($t_partners==0)
echo "Ничего не найдено";
else
{
echo "";
// echo "| Марка | Партнер ta4ka.ru | Адрес | Телефон | WWW / E-mail | Примечания | Прайс-листы | ";
for ($i=0;$i<$t_partners;$i++)
{
$p_id=mysql_result($partners,$i,"id");
$p_cars1_id=mysql_result($partners,$i,"cars1_id");
$p_cars2_id=mysql_result($partners,$i,"cars2_id");
$p_cars3_id=mysql_result($partners,$i,"cars3_id");
$p_cars1_name=@mysql_result(@mysql_query("select name from cars_names where id=$p_cars1_id"),0,"name");
$p_cars2_name=@mysql_result(@mysql_query("select name from cars_names where id=$p_cars2_id"),0,"name");
$p_cars3_name=@mysql_result(@mysql_query("select name from cars_names where id=$p_cars3_id"),0,"name");
$p_name=mysql_result($partners,$i,"name");
$p_city_id=mysql_result($partners,$i,"city_id");
$p_city_name=@mysql_result(@mysql_query("select name from cities where id=$p_city_id"),0,"name");
$p_address=mysql_result($partners,$i,"address");
$p_phone=mysql_result($partners,$i,"phone");
$p_web=mysql_result($partners,$i,"web");
$p_email=mysql_result($partners,$i,"email");
$p_comments=mysql_result($partners,$i,"comments");
$p_user_id=mysql_result($partners,$i,"user_id");
echo "| ";
echo " | ";
}
echo " ";
}
echo "
";
}
echo " | ";
?>
|
|
|
