"; $sql="SELECT l.fob_id, l.merchant_id, l.fob_nm, s.width_no, s.height_no, s.align_cd, l.img_url, l.link_url, l.tag_url, l.display_txt, l.html, date_format(l.end_dt,'%m/%e/%Y') end_dt, info_tag, l.weight, l.cj_id, g.can_id, g.store_nm FROM FOB_Listing l LEFT JOIN Golden_Can g ON l.merchant_id = g.merchant_id LEFT JOIN Ad_Size s ON l.size_id = s.size_id WHERE (l.html like '%shipping%') and l.active_yn = 'Y' and l.start_dt <= curdate() and (l.end_dt >= now() or l.end_dt = '0000-00-00' or l.end_dt is null) and l.size_id = s.size_id ORDER BY l.weight DESC"; if ($result=mysql_query($sql)) { while ($row=mysql_fetch_row($result)) { list($fob_id, $merchant_id, $fob_nm, $width_no, $height_no, $align_cd, $img_url, $link_url, $tag_url, $display_txt, $html, $end_dt, $info_tag, $weight, $cj_id, $can_id, $store_nm) = $row; $endStr = ($end_dt=="" or substr($end_dt,0,2) == '00')? '' : ' [ends '.$end_dt.']'; $endStr .= ($weight==1)? "\n" : "

Category Specials

"; // print top menu list($season_cat, $season_nm, $season_file) = sqlRow("SELECT category_id, category_nm, file_nm FROM FOB_Category WHERE season_end > now() ORDER BY season_end"); fobMenu($category_id,-5,'top','index.html','index'); echo ' ~ '; fobMenu($category_id,2,'top','stores.html','stores','Inventory of Select Internet Stores'); echo ' ~ '; fobMenu($category_id,1,'top','sales.html','sales','Internet Sales and Coupons'); echo ' ~ '; fobMenu($category_id,15,'top',"lastmin.html","last minute","Last Minute"); echo ' ~ '; fobMenu($category_id,5,'top',"factory.html","factory direct","Factory Direct Stores"); echo ' ~ '; fobMenu($category_id,6,'top',"deals.html","daily deals"); echo " ~ "; fobMenu($category_id,3,"top","discount.html","discount"); echo " ~ "; fobMenu($category_id,4,"top","clearance.html","clearance"); echo "

'.$title.'

'; if ($showSide) { echo '

'; // side menu fobMenu($category_id,-2,'side',"index.html",'Home'); echo "
\n"; fobMenu($category_id,$season_cat,'side',$season_file,$season_nm,$season_nm); echo "
\n"; fobMenu($category_id,14,'side',"gifts.html","gifts","Online gift shops"); echo "
\n"; fobMenu($category_id,7,'side',"apparel.html","apparel","Clothing stores"); echo "
\n"; fobMenu($category_id,42,'side',"books.html","bookstores","Bookstores"); echo "
\n"; fobMenu($category_id,35,'side',"crafts.html","arts / crafts","Craft stores"); echo "
\n"; fobMenu($category_id,9,'side',"electronics.html","electronics","Computers and electronic stores"); echo "
\n"; fobMenu($category_id,47,'side',"music.html","music","Musical Instruments and recording equipment"); echo "
\n"; fobMenu($category_id,10,'side',"finance.html","finance","Online Financial Institutions"); echo "
\n"; fobMenu($category_id,10,'side',"gold.html","preparedness","Find preparedness supplies and precious metal coins."); echo "
\n"; fobMenu($category_id,28,'side',"health.html","health","Health stores and nutritional products"); echo "
\n"; fobMenu($category_id,40,'side',"baby.html","infants / toddlers","Baby stores"); echo "
\n"; fobMenu($category_id,29,'side',"kids.html","hobbies / toys","Hobby and toy stores"); echo "
\n"; fobMenu($category_id,37,'side',"learning.html","learning tools","Education web sites and learning tools"); echo "
\n"; fobMenu($category_id,39,'side',"kitchen.html","kitchen","Cooking Supplies"); echo "
\n"; fobMenu($category_id,31,'side',"home.html","home","Stores for the home and garden."); echo "
\n"; fobMenu($category_id,11,'side',"internet.html","internet","Find quality Internet services"); echo "
\n"; fobMenu($category_id,15,'side',"office.html","office","Office Supplies, equipment and furniture"); echo "
\n"; fobMenu($category_id,32,'side',"pet.html","pets","Pet Stores and animal supplies"); echo "
\n"; fobMenu($category_id,26,'side',"photo.html","photography","Photographic stores, cameras and online services"); echo "
\n"; fobMenu($category_id,30,'side',"print.html","printing","Printing supplies and services"); echo "
\n"; fobMenu($category_id,8,'side',"auto.html","automobiles","Online auto stores"); echo "
\n"; fobMenu($category_id,43,'side',"outdoors.html","outdoors","Gear up for your next adventure"); echo "
\n"; fobMenu($category_id,44,'side',"bikes.html","bikes","Bike shops and Triathlon supplies"); echo "
\n"; fobMenu($category_id,46,'side',"boating.html","boating","Boating and Fishing gear."); echo "
\n"; fobMenu($category_id,33,'side',"person.html","personalized","Find personalized, engraved or customized products."); echo "
\n"; fobMenu($category_id,12,'side',"sports.html","sports","Sports and outdoor equipment"); echo "
\n"; fobMenu($category_id,41,'side',"shoes.html","shoes","Find comfy footwear"); echo "
\n"; fobMenu($category_id,47,'side',"entertainment.html","entertainment","Find media and entertaining links."); echo "
\n"; fobMenu($category_id,13,'side',"travel.html","travel","Travel and Hotel Bargains"); echo "
\n"; fobMenu(0,-1,'side',"about.html","about"); echo "
\n"; fobMenu(0,-1,'side',"privacy.html","privacy"); echo '

Sharing:

'; echo "

\n"; } } function fobFoot($moreLine="") { if ($moreLine != "") { echo "\n

$moreLine

\n"; } echo "\n