\n";
echo "\n";
echo "\n";
echo "| Наименование | \n";
echo "Ед.изм. | \n";
echo "Цена | \n";
echo "НДС | \n";
echo " \n";
$db = mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($main_db,$db);
$sql="SELECT * FROM pricelist WHERE category = 'HYCEL' OR category = 'HYCEL-HEM'";
$result=mysql_query($sql,$db);
$num = mysql_num_rows($result);
$cur = 1;
while ($num >= $cur) {
$row = mysql_fetch_array($result);
$description = $row["description"];
$unit = $row["unit"];
$vat = $row["vat"];
$price = $row["price"];
$price = ereg_replace (",", ".", $price);
$rub_price = round((($price + ($price / 100 * $vat))* $dollar_rate),2);
if ($description != "separator") {
if (($cur%2) == 0) { $mystyle = "prctbl-even"; $mystyle_r = "prctbl-even-r"; } else { $mystyle = "prctbl"; $mystyle_r = "prctbl-r"; }
echo "\n";
echo "| $description | \n";
echo "$unit | \n";
echo "$price | \n";
echo "$vat | \n";
echo " \n";
} else {
echo "\n";
echo "| $cat_no | \n";
echo " \n";
}
$cur++;
}
echo " |
