В вашей корзине: товар(ов)
(4742) 366-366
\n"; echo ""; echo "
\n"; echo "

$H1_pages

\n"; echo "
\n"; include('php/poisk2.php'); echo "
"; echo "
"; ?>


ГлавнаяКаталог лекарственных средств";} if ($tipPages==2) { echo "Каталог медицинской техниики";} ?> →
 
"; $quer="select * from LEKARSTVA WHERE ID_LEK IN (SELECT ID_SVLEK FROM SV_LEK_GR WHERE ID_SVGR =\"".$id_gr_name."\") ORDER BY NAME_LEK ASC;"; if ($metodSort==2){ $quer="SELECT ID_LEK,NAME_LEK,NAME_LEK_LAT,INSTR_LEK,DESCR_LEK,CENA_LEK,PIC_LEK,LEK_STRANA,SV_LEK_GR.SORT_SV FROM LEKARSTVA LEFT JOIN SV_LEK_GR ON LEKARSTVA.ID_LEK = SV_LEK_GR.ID_SVLEK WHERE ID_LEK IN (SELECT ID_SVLEK FROM SV_LEK_GR WHERE ID_SVGR =\"".$id_gr_name."\") ORDER BY SORT_SV ASC;"; } $rqqq=mysql_query($quer) or die("Unable to read title"); $NumLek = @mysql_num_rows($rqqq); if ($NumLek == 0){ echo "В данной рубрике лекарства еще не размещены"; } ELSE { $NumLek = 0; while ($row = mysql_fetch_array($rqqq, MYSQL_ASSOC)) { // --------- Проверка на наличии в списке спецпредложений $InSpec = -1; $queryInSpec = "SELECT * FROM SPEC_LEK WHERE ID_SPEC_LEK =".$row[ID_LEK].";"; $rInSpec = mysql_query($queryInSpec); if (mysql_num_rows($rInSpec)>0) { $InSpec=1; while ($rSpecIN = mysql_fetch_array($rInSpec, MYSQL_ASSOC)) { $NEW_CENA = $row[CENA_LEK]-(integer)($row[CENA_LEK] * $rSpecIN[SPEC_SKIDKA_PROC]/100); $nSPEC_SKIDKA = $rSpecIN[SPEC_SKIDKA_PROC]; } // -- проверка на спец цену ---- if ($NEW_CENA <> $rInSpec[NEW_CENA_LEK]) { $queryAdd = "UPDATE SPEC_LEK SET NEW_CENA_LEK = ".$NEW_CENA." WHERE ID_SPEC_LEK = ".$rInSpec[ID_SPEC_LEK].";"; $res_spec_cena = mysql_query($queryAdd); } // ------------------------------ while ($rSpecIN = mysql_fetch_array($rInSpec, MYSQL_ASSOC)) { $NEW_CENA = $rSpecIN[NEW_CENA_LEK]; } } // ------------------------------------------------------ $NumLek = $NumLek + 1; if ($NumLek==5) { $NumLek=1; } if ($NumLek == 1){ echo ""; } if ($NumLek == 2){ } if ($NumLek == 3){ } if ($NumLek == 4){ } echo "\n\r\n\r"; echo "\n\r"; echo "\n\r"; echo "\n\r"; echo "\n\r"; echo "\n\r
"; echo "\n\r"; echo ""; echo ""; echo $row[NAME_LEK]; echo ""; if ($InSpec==1) { echo " (-".$nSPEC_SKIDKA."%)"; } echo "\n\r
\n\r"; echo ""; echo "\n\r".$row[NAME_LEK]." - ".$title."\n\r".substr(strip_tags($row[DESCR_LEK]),0,400).""; echo ""; echo "\n\r
"; echo "
"; echo "\n\r"; echo ""; echo "
"; echo ""; echo ""; echo ""; echo "
"; echo "Страна: ".$row[LEK_STRANA]."
"; echo "
"; echo "Цена: "; echo ""; if ($InSpec==1) { echo "".$NEW_CENA." "; } if($row[CENA_LEK]=="") {echo "уточняйте";} echo $row[CENA_LEK]; if ($InSpec==1) { echo ""; } if($row[CENA_LEK]<>"") {echo " р. ";} echo ""; echo "
"; echo "
"; echo "
"; echo " "; if ($NumLek == 1){ } if ($NumLek == 2){ } if ($NumLek == 3){ } if ($NumLek == 4){ echo ""; } } if ($NumLek == 1){ echo ""; echo ""; echo ""; } if ($NumLek == 2){ echo ""; echo ""; } if ($NumLek == 3){ echo ""; } echo ""; } ?>
ГлавнаяКаталог лекарственных средств



apteka48.ru

Разработка сайта и продвижение сайта - СеоПрайм