Eyelash Extensions

'; /*$Script .= ' ";*//* $main .= " \"Original
";*/ $q_specials1 = mysql_query(" SELECT SQL_CACHE t2.*, t2.name_$lang AS drug_name, t3.name_$lang AS brand_name, t3.id as brand_id, t3.img as brand_img, t3.promo_desc, t2.price AS price, t1.discount AS discount, t1.img AS img, t3.img as altimg, t4.name_$lang AS categ_name FROM discounts t1 INNER JOIN drug t2 ON t1.drug = t2.id INNER JOIN brand t3 ON t2.brand = t3.id INNER JOIN categ t4 ON t3.categ = t4.id WHERE 1 AND t1.date_off > NOW() AND t1.display = 1 ORDER BY t2.brand, t2.ord, t2.price ASC "); $main .= ' '; $j=0; $k++; $num = mysql_num_rows($q_specials1); if ($num > 0) $main .= '
'; while ($row = mysql_fetch_assoc($q_specials1)) { /* if ($row_block[img] == "") $row_block[img] = $row_block[altimg]; $image = 'images/drugs_sale/'.intval($row_block['discount']).'-'.$row_block[brand_img]; //$image = "images/drugs/".str_replace(",", "", str_replace(".", "", str_replace("-", "_", str_replace(" ", "_", $row_block['drug_name']))))."-".$row_block[brand_img]; $old_price = number_format($row_block['price'], 2, '.', '' ); $new_price = number_format(($row_block['price']-$row_block['discount']), 2, '.', '' ); $link_cart = '/cart/'.$row_block['id']."/"; $descr = $row_block[quant].' X '.$row_block[dose].'mg'; $text = $row_block[promo_desc]; $name = $row_block[drug_name]; $uri = str_replace("&", "and", strtolower(str_replace(" ", "_", $row_block['categ_name'].'/buy_'.$row_block['brand_name']))); $q0 = mysql_query ("SELECT t1.* FROM drug t1 WHERE t1.brand = '".$row_block[brand_id]."' AND (t1.sv_type > 0 OR t1.sv_type = -2) ORDER BY t1.ord"); $i=1;$ind=""; while ($r0 = mysql_fetch_array($q0)) { if ($row_block[id] == $r0[id]) $ind = $i; $i++; } $link = "/order_online/".$uri.".html"; $main .= view_best1 ($name, $row_block[brand_name], $descr, $text, $old_price, $new_price, $image, $link, $link_cart); $j++;$k++; if ($j==2) { $j=0; $main .= ''; if ($num != $k -1) $main .= ''; } } $main .= '
*/ $row['name_en'] = str_replace('(USA to USA 2-5 Days Shipping)', '', $row['name_en']); $url = "/order_online/".str_replace("&", "and", strtolower(str_replace(" ", "_", $row['categ_name'].'/buy_'.$row['brand_name']))).".html"; $main .= ' '.str_replace("Brand", 'Brand®', $row['name_en']).' '.CURRENCY.number_format($row['price']-$row[discount],2,".","").($row[discount]==0?'':" (-$".$row[discount].")").' '.(($row[sv_type]==3 || $row[sv_type]==4)?'SOLD OUT':'').'
'; $i++; } $main .= ''; /*New Products
'; $q_specials1 = mysql_query(" SELECT SQL_CACHE t2.*, t2.name_$lang AS drug_name, t3.name_$lang AS brand_name, t3.id as brand_id, t3.img as brand_img, t3.promo_desc, t2.price AS price, t3.img as altimg, t4.name_$lang AS categ_name FROM drug t2 INNER JOIN brand t3 ON t2.brand = t3.id INNER JOIN categ t4 ON t3.categ = t4.id WHERE 1 and t2.new = '1' ORDER BY t2.name_en, t2.dose, t2.brand, t2.ord, t2.price ASC "); while ($row = mysql_fetch_assoc($q_specials1)) { $row['name_en'] = str_ireplace('(USA to USA 2-5 Days Shipping)', '', $row['name_en']); $row['name_en'] = str_replace('(US', '( US', $row['name_en']); $url = "/order_online/".str_ireplace("&", "and", strtolower(str_replace(" ", "_", $row['categ_name'].'/buy_'.$row['brand_name']))).".html"; $main .= ' '; $i++; } $main .= '
'.str_ireplace("Brand", 'Brand®', $row['name_en']).' '.CURRENCY.number_format($row['price']-$row[discount],2,".","").($row[discount]==0?'':" (-$".$row[discount].")").' '.CURRENCY.number_format(($row['price']-$row[discount])/$row[quant],2,".","").' p/pill '.(($row[sv_type]==3 || $row[sv_type]==4)?'SOLD OUT':'').'

'; */ /////////*/ $q_specials=mysql_query(" SELECT SQL_CACHE t4.name_en AS brand_name, t4.id as brand_id, t4.img as brand_img, t4.promo_desc, t5.name_en AS categ_name, t3.id as id, t3.price, t4.promo_desc FROM orders t1 INNER JOIN items t2 ON t2.orders = t1.id INNER JOIN drug t3 ON t2.drug = t3.id INNER JOIN brand t4 ON t3.brand = t4.id INNER JOIN categ t5 ON t4.categ = t5.id and t1.data_ord > DATE_SUB(CURDATE(),INTERVAL 7 DAY) and t1.sv_type not like 'D' and t1.sv_type not like 'I' GROUP BY t4.name_en ORDER BY sum(t2.quant) DESC LIMIT 12 "); $j=0; $k++; $num = mysql_num_rows($q_specials); $main .= '

'; while ($row_block = mysql_fetch_array($q_specials)) { $link_cart = '/cart/'.$row_block['id']."/"; $uri = '/order_online/'.str_replace("&", "and", strtolower(str_replace(" ", "_", $row_block['categ_name'].'/buy_'.$row_block['brand_name']))).'.html'; $image = 'images/drugs_sale/'.intval($row_block['discount']).'-'.$row_block[brand_img]; $main .= view_best ($row_block[brand_name], $row_block[brand_name], $row_block[price], $row_block[promo_desc], '', '', $image, $uri, $link_cart); //if ($row_block[img] == "") $row_block[img] = $row_block[altimg]; $j++;$k++; if ($j==2) { $j=0; $main .= ''; if ($num != $k -1) $main .= ''; } } $main .= '
'; $main .= '
'; /* $q_specials = mysql_query(" SELECT t2.*, t2.name_$lang AS drug_name, t3.name_$lang AS brand_name, t3.id as brand_id, t3.img as brand_img, t3.promo_desc, t2.price AS price, t1.discount AS discount, t1.img AS img, t3.img as altimg, t4.name_$lang AS categ_name FROM discounts t1 INNER JOIN drug t2 ON t1.drug = t2.id INNER JOIN brand t3 ON t2.brand = t3.id INNER JOIN categ t4 ON t3.categ = t4.id WHERE 1 AND t1.date_off > NOW() AND t1.display = 1 ORDER BY t2.name_en limit 12 "); $main .= '

'; $j=0; $k++; $num = mysql_num_rows($q_specials); while ($row_block = mysql_fetch_assoc($q_specials)) { $image = 'images/drugs_sale/'.intval($row_block['discount']).'-'.$row_block[brand_img]; //$image = "images/drugs/".str_replace(",", "", str_replace(".", "", str_replace("-", "_", str_replace(" ", "_", $row_block['drug_name']))))."-".$row_block[brand_img]; $old_price = number_format($row_block['price'], 2, '.', '' ); $new_price = number_format(($row_block['price']-$row_block['discount']), 2, '.', '' ); $link_cart = '/cart/'.$row_block['id']."/"; $descr = $row_block[quant].' X '.$row_block[dose].'mg'; $text = $row_block[promo_desc]; $name = $row_block[drug_name]; $uri = str_replace("&", "and", strtolower(str_replace(" ", "_", $row_block['categ_name'].'/buy_'.$row_block['brand_name']))); $q0 = mysql_query ("SELECT t1.* FROM drug t1 WHERE t1.brand = '".$row_block[brand_id]."' AND (t1.sv_type > 0 OR t1.sv_type = -2) ORDER BY t1.ord"); $i=1;$ind=""; while ($r0 = mysql_fetch_array($q0)) { if ($row_block[id] == $r0[id]) $ind = $i; $i++; } $link = "/order_online/".$uri.".html"; $main .= view_best ($name, $row_block[brand_name], $descr, $text, $old_price, $new_price, $image, $link, $link_cart); $j++;$k++; if ($j==2) { $j=0; $main .= ''; if ($num != $k -1) $main .= ''; } } $main .= '
';*/ //$main .= view_brands($lang);*/ $main .= '100% shipping guarantee'; } if ($page = sv_strip_specials($_GET['page'])) { $page = str_replace("_", " ", $page); $page = strtolower(str_replace("and", "%", $page)); $q_state = " SELECT t2.*, t1.name_$lang AS page_name FROM page t1, art t2 WHERE t2.page=t1.id AND LCASE(t1.name_$lang) LIKE LCASE('$page') ORDER BY t2.ord, t2.id DESC "; } elseif ($menu + 0) { $q_state = " SELECT t2.*, t1.name_$lang AS page_name FROM menu t0, page t1, art t2 WHERE t1.menu = t0.id AND t2.page = t1.id AND t0.id = '$menu' ORDER BY t2.ord, t2.id DESC "; } else { $id += 0; $q_state = " SELECT t2.*, t1.name_$lang AS page_name FROM page t1 LEFT JOIN art t2 ON t2.page=t1.id AND t2.sv_type <> 0 WHERE t1.uin='$id' ORDER BY t2.ord, t2.id DESC "; } $q_state = mysql_query($q_state); echo mysql_error(); $row = mysql_fetch_array($q_state); if ($row['page_name']!="Latest News" && $row['page_name']!="") $main .= '

'.$row['page_name'].'

'; if ($q_state) mysql_data_seek($q_state, 0); $iii = 0; while ($row = mysql_fetch_array($q_state)){ if ($iii > 0) $main .= ''; $row[$lang] = str_ireplace('--BackLink--', '
< Go to Questions
', $row[$lang]); $main .= '
'.$row[$lang]."
"; $iii ++; } if (!($menu || $page || $id)) { $main .= '

The Meds-Order.com Benefits:




We requires a copy of a prescription in order to send any order. That prescription must be written by a licensed US physician if you are in the United States. If you order from another country, the prescription has to be written by a doctor located where the shipping address is.
After placing your order please fax or email a copy of your order along with your original prescription and a copy of your Driver\'s License (or other photo ID) by one of the following methods

'; } include_once("bot.php"); ?>