"; echo "      ". $name .""; $table_name="store"; $sql = "SELECT * FROM $table_name WHERE FIND_IN_SET('$catid', catid) > 0 order by storename"; $results = mysql_query($sql) or die("Couldn't execute query"); while ($row= mysql_fetch_array($results)) { $storeid = $row["storeid"]; $storename0 = $row["storename"]; $storeimage = $row["logo"]; $banner = $row["banner"]; $storename = str_replace(" ", "-", $storename0); echo "
"; echo "

"; echo "
"; echo " "; echo "   "; echo " "; echo " "; echo " "; echo " "; echo " "; $sql = "SELECT * FROM coupons"; $sql .= " WHERE storeid = $storeid order by expire;"; $result = mysql_query($sql) or die("Couldn't execute query"); $numRows = mysql_numrows($result); if ($numRows > 0) { echo " "; echo " "; echo " "; } /* Printing results in HTML */ # loop through results for($i=0;$i<$numRows;$i++){ # print results # mixed mysql_result ( resource result, int row [, mixed field]) # for example, the date $id = mysql_result($result, $i, "id"); $store = mysql_result($result, $i, "store"); $coupon= mysql_result($result, $i, "coupon"); $expire= mysql_result($result, $i, "expire"); $code= mysql_result($result, $i, "code"); $couponlink = mysql_result($result, $i, "address"); $target = "_blank"; if (strpos($couponlink, "dealinstyle.com")) { $target = "_self"; } $yorn = 1; if (strcmp($expire, "0000-00-00")==0) {$yorn = 2; } else { $currentdate = date("Y-m-d"); if (strcmp($currentdate, $expire)>0) { $yorn = 0; } else { $expire = date("n/j", strtotime($expire)); } } if ($yorn == 1) { if (strcmp($code, "none")==0 | strlen($code)<2) { echo ""; } else { echo ""; } } if ($yorn == 2) { if (strcmp($code, "none")==0 | strlen($code)<2) { echo ""; } else { echo ""; } } } echo "
"; echo "

"; echo $banner; echo "

"; echo " 		 
"; echo "
"; echo "

"; echo " $storename0 Coupons

"; echo "
". $coupon ."  [Exp ". $expire ."]
". $coupon ."   Code: ". $code ."  [Exp ". $expire ."]
". $coupon ."
". $coupon ."   Code: ". $code ."
"; echo "
"; echo "
"; echo "

"; } } ?> "; echo "\n"; echo "\n"; } else { echo ""; echo "\n"; } echo "\n". $pagetitle .""; ?> Hot deals Savings grouped by stores Coupons grouped by categories Weekly specials and more Communities
Coupons Broken Down Into Over 70 Categories
"; if (empty($catid)) { include("list.html"); } else { if (strcmp($parents,'0')==0) { $id = mysql_result($resultc, 0, "id"); $sqlcs = "SELECT * FROM category WHERE FIND_IN_SET('$id', parents) > 0 order by name"; $resultcs = mysql_query($sqlcs) or die("Couldn't execute query"); while ($rowcs= mysql_fetch_array($resultcs)) { $name = $rowcs["name"]; $catid = $rowcs["id"]; storebox($catid, $name); } } else { storebox($catid, $name); } } mysql_close(); ?>