Win Canadian Cash Contests

data_seek($row); $datarow = $res->fetch_array(); return $datarow[$field]; } $conn = mysqli_connect('localhost', 'scenterm_ac2', 'vut6qnbckz') or die(mysqli_error()); $db_selected = mysqli_select_db($conn, "scenterm_accontests") or die(mysqli_error()); $sqlnum = "SELECT count(*) as sum FROM SweepDirectory WHERE category = '$pagecategory' and status = 'Y' and enddate > DATE_SUB(CURDATE(), INTERVAL 1 DAY) ORDER BY enddate ASC "; $resultnum = mysqli_query($conn, $sqlnum); $marr = mysqli_fetch_array($resultnum); $count = $marr['sum']; if(empty($_REQUEST['page'])) { $curpage = 1; } else { $curpage = $_REQUEST['page']; } $start = ($curpage-1)*12; $pager = new pager(); $sql = "SELECT * FROM SweepDirectory WHERE category = '$pagecategory' and status = 'Y' and enddate > DATE_SUB(CURDATE(), INTERVAL 1 DAY) ORDER BY enddate ASC LIMIT $start,12 "; //echo $sql; $result = mysqli_query($conn, $sql); $num= mysqli_num_rows($result); $i=0; while ($i < $num) { $sid=mysqli_result($result,$i,"sid"); $startdate=mysqli_result($result,$i,"startdate"); $sponsor=mysqli_result($result,$i,"sponsor"); $category=mysqli_result($result,$i,"category"); $prizevalue=mysqli_result($result,$i,"prizevalue"); $prize=mysqli_result($result,$i,"prize"); $url=mysqli_result($result,$i,"url"); $enddate=mysqli_result($result,$i,"enddate"); $frequency=mysqli_result($result,$i,"frequency"); $country=mysqli_result($result,$i,"country"); $AB=mysqli_result($result,$i,"AB"); $BC=mysqli_result($result,$i,"BC"); $MB=mysqli_result($result,$i,"MB"); $NB=mysqli_result($result,$i,"NB"); $NL=mysqli_result($result,$i,"NL"); $NT=mysqli_result($result,$i,"NT"); $NS=mysqli_result($result,$i,"NS"); $NU=mysqli_result($result,$i,"NU"); $NB=mysqli_result($result,$i,"ONT"); $PE=mysqli_result($result,$i,"PE"); $QC=mysqli_result($result,$i,"QC"); $SK=mysqli_result($result,$i,"SK"); $YT=mysqli_result($result,$i,"YT"); $english_format_number = number_format($prizevalue); date_default_timezone_set("America/Toronto"); $candidateDateString = "$startdate"; $candidate = new DateTime ($candidateDateString); $interval = DateInterval::createFromDateString ('7 days'); $now = new DateTime(); $boundary = $now->sub($interval); if($i === 3){ include 'inc-ad-3rd-listing.html'; } if($i === 4){ include 'inc-ad-4th-listing.html'; } if($i === 6){ include 'inc-ad-6th-listing.html'; } if($i === 8){ include 'inc-ad-8th-listing.html'; } if($i === 9){ include 'inc-ad-9th-listing.html'; } echo " "; $i++; } echo " "; ?>
Prize Details Value End Date Frequency
"; if ($candidate > $boundary) { echo "New  "; } else { echo ""; } echo" $sponsor $prize $$english_format_number $enddate $frequency
Pages :".$pager->pageListSimple($curpage, $pager->findPages($count, 12))."