Random Sales

'; $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 FROM FOB_Listing l LEFT JOIN Ad_Size s ON l.size_id = s.size_id WHERE l.category_id = $category_id and l.active_yn = 'Y' and l.start_dt <= curdate() and l.end_dt >= now() 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" : "

Text Ads

• "; } else { echo "
• "; } } elseif ($cnt++ >0) echo "

  \n"; if ($cj_id > 0) { $disp = '

  '; $disp .= '
  '; } elseif ($align_cd == 'T') { $disp = ($display_txt=='')? '' : ''.$display_txt.''; } else { $disp = ($img_url=='')? $display_txt." " : "\n"; } if ($tag_url !='') $tags .= "\n"; if ($can_id > 0) $html .= ' (more bargains) '; echo ($cj_id >0)? $disp.$html.$endStr : "$disp".$html.$endStr; } } else { echo "SQL Error ".mysql_error(); } if (!$mainSection) echo "

'.$store_nm.'

'.$txt.$storeStr.'

a Fountain of Bargains - Coupons and Sales

The block below lists coupons and sales for select merchants followed by a free form list of sales from around the Internet.