0) { $myrow_rate = mysql_fetch_array($result_rate); $rate = $myrow_rate['data']; } if (isset($id)) { $id = stripslashes ($id); $id = htmlspecialchars ($id); $result = mysql_query ("SELECT * FROM tovar WHERE id=$id"); if (mysql_num_rows($result) < 1) { exit (); } $myrow = mysql_fetch_array ($result); $title=$myrow[title]; $meta_d=$myrow[meta_d]; $meta_k=$myrow[meta_k]; if($myrow[cat] == 'Капсулы nespresso') { $result_rate = mysql_query ("SELECT * FROM rate WHERE id=".(int)2,$db); if (mysql_num_rows($result_rate) > 0) { $myrow_rate = mysql_fetch_array($result_rate); $rate = $myrow_rate['data'];} } $price = round($myrow[price]*$rate); if($myrow[discount]!='0') { $price = round(($myrow[price]-($myrow[price]*$myrow[discount]/100))*$rate); } } else { $cat = stripslashes ($cat); $cat = htmlspecialchars ($cat); $cat=str_replace("_"," ",$cat); $result4 = mysql_query ("SELECT title,meta_d,meta_k,view FROM menu WHERE punkt='$cat'"); if (mysql_num_rows($result4) < 1) { exit (); } $myrow4 = mysql_fetch_array ($result4); $title=$myrow4[title]; $meta_d=$myrow4[meta_d]; $meta_k=$myrow4[meta_k]; $view_cat=$myrow4[view]; } ?> ".$cat."

"; $result = mysql_query ("SELECT * FROM tovar WHERE cat = '$cat' AND archive = 0 ORDER BY sort",$db); $myrow = mysql_fetch_array($result); do { $t_id=$myrow['id']; $result00 = mysql_query("SELECT COUNT(*) FROM comments WHERE tovar_id='$t_id'"); $temp= mysql_fetch_array($result00); $amount_comments = $temp[0]; $v = $myrow["vote"]/$myrow["q_vote"]; $v = round ($v,1); $v_img = intval ($v); $price = round($myrow['price']*$rate); $new_product = ''; if($myrow["discount"]!='0') { $price = round(($myrow['price']-($myrow['price']*$myrow['discount']/100))*$rate); } if($myrow["new_product"]=='1') { $new_product = "

"; } if($cat == 'Капсулы nespresso') { $result_intensity = mysql_query("SELECT value_ch FROM characteristics WHERE id_tovar='$t_id' AND name_ch='Интенсивность обжарки (крепость)'"); if (!$result_intensity) { $intensity = "Интенсивность обжарки (крепость): - "; } else { $myrow_intensity = mysql_fetch_array($result_intensity); $intensity = "Интенсивность обжарки (крепость): ".$myrow_intensity['value_ch'].""; } } echo ""; print "

".$myrow[

увеличить

".$new_product."

".$myrow['mtitle']."

".$myrow['description']."

".$intensity."

Подробнее ...

Цена: "; if($myrow["discount"]!='0') { echo " ~~".round($myrow['price']*$rate)." грн.~~ Акция! -".$myrow['discount']."% "; } echo $price." грн.

"; $stock=" Купить "; if($myrow["in_stock"]=='0') { $stock="Нет в наличии"; } if(isset($_SESSION['product'])) { foreach($_SESSION['product'] as $key => $value) { if ($key==$myrow['id']) $stock=" в корзине "; } } echo "

".$stock."

"; echo" Комментарии / отзывы: ".$amount_comments."

Рейтинг ".$v." из 5

"; } while ($myrow = mysql_fetch_array($result)); } if (!isset ($id) && $view_cat == '1') { echo "

".$cat."

".$meta_d."

"; $result = mysql_query ("SELECT * FROM tovar WHERE cat = '$cat' AND archive = 0 ORDER BY sort",$db); $myrow = mysql_fetch_array($result); do { echo "

".$myrow[

увеличить
".$myrow['mtitle']."

"; } while ($myrow = mysql_fetch_array($result)); echo "

"; } if (isset ($id) && $myrow["model"] != '0') { echo "

".$myrow["mtitle"]."

".$myrow["mtitle"]."

"; echo "

Характеристики:

"; $result_ch = mysql_query ("SELECT * FROM characteristics WHERE id_tovar = '$id'",$db); $myrow_ch = mysql_fetch_array($result_ch); do { echo "".$myrow_ch["name_ch"].": ".$myrow_ch["value_ch"]."
"; } while ($myrow_ch = mysql_fetch_array($result_ch)); $v = $myrow["vote"]/$myrow["q_vote"]; $v = round ($v,1); $v_img = intval ($v); $result_comm = mysql_query("SELECT COUNT(*) FROM comments WHERE tovar_id='$id'"); $temp_comm = mysql_fetch_array($result_comm); echo " Производитель (бренд): ".$myrow["marka"]."
Модель: ".$myrow["model"]."

Цена: "; if($myrow["discount"]!='0') { echo " ~~".round($myrow['price']*$rate)." грн.~~ Акция! -".$myrow['discount']."% "; } echo "".$price." грн. " ; $stock=" Купить "; if($myrow["in_stock"]=='0') { $stock="Нет в наличии"; } if(isset($_SESSION['product'])) { foreach($_SESSION['product'] as $key => $value) { if ($key==$myrow['id']) $stock=" в корзине "; } } echo "

".$stock."

"; echo "

Рейтинг:

Рейтинг ".$v." из 5

(Рейтинг ".$v." из 5, голосов - ".$myrow["q_vote"].") Отзывов:".$temp_comm[0]."

Описание:

".$myrow["text"]."

"; } if (isset ($id) && $myrow["model"] == '0') { echo "

".$myrow["mtitle"]."

".$myrow["text"]."

"; } /*Комментарии*/ if (isset($id)) { echo ""; $result3 = mysql_query ("SELECT * FROM comments WHERE tovar_id='$id' ORDER BY id",$db); if (mysql_num_rows($result3) > 0) { $myrow3 = mysql_fetch_array($result3); echo "

Коментарии / Отзывы:

"; do { printf ("

Коментарий / отзыв добавил(а): %s
Дата: %s

%s

",$myrow3 ["author"],$myrow3 ["date"],$myrow3 ["text"]); } while ($myrow3 = mysql_fetch_array($result3)); } $ch1= rand (0,15); $ch2= rand (0,15); echo "

Добавьте Ваш комментарий / отзыв:

"; } /*Закончились комментарии*/ ?>