echo $name_company_cats2;?>
Контакты:
echo $address_company_cats2;?>
Список товаров и услуг echo $name_company_cats2;?>
$query_cats1=mysql_query("SELECT DISTINCT `parent_id` FROM `product` WHERE `company_id` = '".$id."' ",$dbcnx);
$arr_rez_cats1=array();
while ($rez_cats1=mysql_fetch_array($query_cats1, MYSQL_NUM))
{
$arr_rez_cats1[]=$rez_cats1;
}
$count_cats1=count($arr_rez_cats1);
if ($count_cats1>0)
{
for ($i=0; $i<$count_cats1; $i++)
{
$query_parr1=mysql_query("SELECT `name`,`parent_id` FROM `category` WHERE `id` = '".$arr_rez_cats1[$i][0]."' ",$dbcnx);
$arr_rez_parr1=array();
while ($rez_parr1=mysql_fetch_array($query_parr1, MYSQL_NUM))
{
$arr_rez_parr1[]=$rez_parr1;
}
$count_parr1=count($arr_rez_parr1);
if ($count_parr1>0)
{
$query_parr2=mysql_query("SELECT `name`, `parent_id` FROM `category` WHERE `id` = '".$arr_rez_parr1[0][1]."' ",$dbcnx);
$arr_rez_parr2=array();
while ($rez_parr2=mysql_fetch_array($query_parr2, MYSQL_NUM))
{
$arr_rez_parr2[]=$rez_parr2;
}
$count_parr2=count($arr_rez_parr2);
}
echo "
".$arr_rez_parr2[0][0]." - ".$arr_rez_parr1[0][0]."
";
$query_cats5=mysql_query("SELECT `id`,`name`,`gost`,`country`,`ed_id` FROM `product` WHERE `company_id` = '".$id."' and `parent_id`='".$arr_rez_cats1[$i][0]."' ",$dbcnx);
$arr_rez_cats5=array();
while ($rez_cats5=mysql_fetch_array($query_cats5, MYSQL_NUM))
{
$arr_rez_cats5[]=$rez_cats5;
}
$count_cats5=count($arr_rez_cats5);
if ($count_cats5>0)
{//
echo "
Товар (услуга) |
Тех. информация |
Ед. изм. |
Цена, сум |
";
for ($i5=0; $i5<$count_cats5; $i5++)
{
$id_cats5=$arr_rez_cats5[$i5][0];
$name_cats5=$arr_rez_cats5[$i5][1];
$gost_cats5=$arr_rez_cats5[$i5][2];
$country_cats5=$arr_rez_cats5[$i5][3];
$ed_id_cats5=$arr_rez_cats5[$i5][4];
$query_edizm=mysql_query("SELECT name FROM `tbl_edizm` WHERE `id`='".$ed_id_cats5."' LIMIT 1 ",$dbcnx);
$arr_rez_edizm=array();
while ($rez_edizm=mysql_fetch_array($query_edizm, MYSQL_NUM))
{
$arr_rez_edizm[]=$rez_edizm;
}
if (count($arr_rez_edizm)==1) $ed_cats5=$arr_rez_edizm[0][0]; else $ed_cats5='???';
$query_price=mysql_query("SELECT price,date FROM `price` WHERE `id_product`='".$id_cats5."' ORDER BY `date` DESC LIMIT 2 ",$dbcnx);
$arr_rez_price=array();
while ($rez_price=mysql_fetch_array($query_price, MYSQL_NUM))
{
$arr_rez_price[]=$rez_price;
}
if (count($arr_rez_price)>=1)
{
$price_price=$arr_rez_price[0][0];
$date_price=$arr_rez_price[0][1];
$date_price="Цена по состоянию на ".$date_price;
}
else
{
$price_price='нет данных';
$date_price='нет данных';
}
if ($price_price=='0') {$price_price='по заявке';}
if (($gost_cats5!='') and ($gost_cats5!='-') and ($country_cats5!='') and ($country_cats5!='-'))
{
$text_gost_cats5=$gost_cats5." (".$country_cats5.")";
}
else
{
if (($gost_cats5=='') or ($gost_cats5=='-')) {$text_gost_cats5=$country_cats5;}
if (($country_cats5=='') or ($country_cats5=='-')) {$text_gost_cats5=$gost_cats5;}
if ((($gost_cats5=='') or ($gost_cats5=='-')) and ($country_cats5=='')) {$text_gost_cats5='';}
}
echo "
".$name_cats5." |
".$text_gost_cats5." |
".$ed_cats5." |
";
if (count($arr_rez_price)>1) echo "";
echo kkk($price_price)." | ";
}
echo "
";
}//
}
}
?>