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 { $price = round($myrow['price']*$rate); if($myrow["discount"]!='0') { $price = round(($myrow['price']-($myrow['price']*$myrow['discount']/100))*$rate); } echo "

"; print "

".$myrow['mtitle']."

Цена: "; 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"

"; } 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['mtitle']."

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

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

".$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)); $result_comm = mysql_query("SELECT COUNT(*) FROM comments WHERE tovar_id='$id'"); $temp_comm = mysql_fetch_array($result_comm); echo " Производитель (бренд): ".$myrow["marka"]."
Модель: ".$myrow["model"]."

Цена: "; 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 "

Описание:

".$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

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

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

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