Search Results for the keyword :

 Click to activate Coupon
There has been an error. This is the error message:

"; echo "

" . mysql_error() . "

"; echo "Please Contant Your Systems Administrator with the details"; } mysql_select_db($dbName, $conn); $stext1 = substr_replace($stext,"",-1); $stext .= "s"; $sql = "SELECT distinct coid, stid, otid, sname, sfolder, description, dealdesc, listprice, currentprice,cofferid, mir, dealimage, finalprice, code, DATE_FORMAT(enddate,'%b %d') as enddate FROM coupondeal WHERE MATCH (description) AGAINST ('{$_GET['stext']}|| $stext1||$stext' IN BOOLEAN MODE) && otid=6 order by rank desc LIMIT 0,50"; $result = mysql_query($sql); if (!$result) {echo "Could not successfully run query ($sql) from DB: " . mysql_error(); exit;} if (mysql_num_rows($result) == 0) {echo " ";} $sp = "'"; while ($row = mysql_fetch_assoc($result)) { } mysql_free_result($result); echo '
'; echo '
Store
'; echo '
'; echo '
Link to On-Line Coupons
'; echo '
Expiry
'; $sql = "SELECT distinct sfolder, sname, stid, coid,otid,description, cofferid, mir, code, DATE_FORMAT(enddate,'%b %d') as enddate FROM coupondeal WHERE MATCH (searchword, sname, description) AGAINST ('{$_GET['stext']}|| $stext1||$stext' IN BOOLEAN MODE) && otid<>6 group by sfolder order by rank desc LIMIT 0,50"; $result = mysql_query($sql); if (!$result) {echo "Could not successfully run query ($sql) from DB: " . mysql_error(); exit;} if (mysql_num_rows($result) == 0) {echo "";} $sp = "'"; while ($row = mysql_fetch_assoc($result)) { echo '
'; $spr=$row["coid"]; echo ''; echo '
'; IF ($row["otid"]>5) {echo '
'.$row["description"].'
  • '.$row["code"].'
  • ';} else {echo '
    '.$row["description"].'
  • '.$row["code"].'
  • ';} echo '
    '.$row["enddate"].' 
    '; } echo ''; echo ''; echo '
    '; echo ''; mysql_free_result($result); echo '
    '; $sql = "SELECT distinct sfolder, sname, stid, coid,otid, description, cofferid, mir, code, DATE_FORMAT(enddate,'%b %d') as enddate FROM coupondeal WHERE description not like '%$stext1%' && otid<>6 && otid<>7 group by sfolder order by rank desc LIMIT 0,15"; $result = mysql_query($sql); if (!$result) {echo "Could not successfully run query ($sql) from DB: " . mysql_error(); exit;} if (mysql_num_rows($result) == 0) {echo ""; exit;} $sp = "'"; echo '
    Featured Coupons
    '; while ($row = mysql_fetch_assoc($result)) { $spr=$row["coid"]; echo '
    '; echo '
    '; echo '
  • '.$row["description"].'

  • '; if($row["code"]<>'') echo '
  • Code: 
  • ' .$row["code"]. '
  •   
  • '; if($row["enddate"]<>'') echo 'Expiry: 
  • '. $row["enddate"]. '
  • '; echo '
    '; } echo '
    '; mysql_free_result($result); ?>

    The Contents of this Webpage are Copyright 2007 CouponAlbum All Rights Reserved.