Search Results for the keyword :

 Click to View Deal
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)) { echo '
'; $zero="0"; if ($row["cofferid"] == 0) { echo '
  • ' .$row["dealdesc"].'
'; } else { echo '
  • ' .$row["dealdesc"].'
'; } $p=0; if($row["listprice"]>0) { echo '
  • List Price: 
  • $' .$row["listprice"].'
  • '; $p=$row["listprice"]; } if($row["currentprice"]>0) { echo '
  • Current Price: 
  • $' .$row["currentprice"].'
'; $p=$row["currentprice"]; } if($row["mir"]>0) { echo '
  • Discount: 
  • $'. $row["mir"].' 
  • '; $p=$p-$row["mir"]; } $f=$p; if ($f!=0) echo '
  •  Final Price: 
  • $'. $f. ' '; echo '
  • Expiry: 
  • '. $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.