Company

Blog Company

PRIVACY POLICY

PRIVACY POLICY Most Recent Update: 9/11/24This Privacy Policy explains how Mercoframes Optical Corp, collects, uses and discloses personalinformation of its customers, prospective customers, and visi ...

PRIVACY POLICY

Leasing

Are you looking into Leasing your next Ophthalmic Equipment? Leasing will help you fight technical obsolescence, cash flow problems and more.

Leasing

General Information

Import duties, taxes and charges are not included in the item price or shipping charges.

WHO WE ARE

If we don't have it, we'll find it!

WHO WE ARE
Old Entries
/* $c_url=null; $s=null; $page=null; if(isset($_GET['c_url'])) $c_url=vParam('c_url', $_GET['c_url'], null); //parametro enviado es el URL de tbl_articles if(isset($_GET['s'])) $s=vParam('s', $_GET['s'], null); //parametro enviado para identificar orden if(isset($_GET['page'])) $page=vParam('page', $_GET['page'], null); //parametro enviado para identificar numero de pagina $dCat=detRow('tbl_articles_cat','cat_url',$c_url); if($dCat){ $idC=$dCat['cat_id']; $dCat_tit=$dCat['cat_nom']; $dCat_des=$dCat['cat_des']; $filG['id']=array('tbl_articles.cat_id','=',$idC); }else{ $dCat_tit="Blog"; $dCat_des='Blog articles, news, events, learning center, promotions and discounts'; } seoGoogleMetas($dCat_tit,$dCat_des); $filG['stat']=array('tbl_articles.status','=','1'); $paramSQL=getParamSQLA($filG); $TR=totRowsTabP('tbl_articles',$paramSQL); if($TR>0){ $pages = new Paginator(); $pages->items_total = $TR; $pages->mid_range = 8; $pages->paginate(); $qrya='SELECT tbl_articles.art_id AS a_id, tbl_articles.art_url AS a_url, tbl_articles.tittle AS a_tit, tbl_articles.image AS a_img, tbl_articles.short_des AS a_sdes, tbl_articles.dcreate as a_date, tbl_articles.hits as a_hits, tbl_articles.featured as a_feat, tbl_articles_cat.cat_nom AS c_nom, tbl_articles_cat.cat_url AS c_url FROM tbl_articles LEFT JOIN tbl_articles_cat ON tbl_articles.cat_id=tbl_articles_cat.cat_id WHERE 1=1 '.$paramSQL.' ORDER BY tbl_articles.art_id DESC '.$pages->limit; $RSa=mysqli_query($conn,$qrya); $dRSa=mysqli_fetch_assoc($RSa); $tRSa=mysqli_num_rows($RSa); } ?>

Blog Company


Warning: mysqli_fetch_assoc(): Couldn't fetch mysqli_result in /home/merco/public_html/views/_blog.php on line 299
Old Entries

Warning: mysqli_free_result(): Couldn't fetch mysqli_result in /home/merco/public_html/views/_blog.php on line 305
*/

You Recently Viewed Items

Events / Shows View all

5555 NW 74 AVE.
MIAMI. FL. 33166
P: 305-882-0120
F: 305-882-0140
info@mercoframes.com
alan@mercoframes.com
WhatsApp +1 305-882-0120
Hangouts alan@mercoframes.net