Below we have the newest contests on AllCanadaContests.com. Click the links to get all the details and enter to win the prizes. The more times you enter the better chances you can win. |
|
Today's New Contests
|
DATE_SUB(curdate(), INTERVAL 2 DAY) and status = 'Y' and enddate > DATE_SUB(CURDATE(), INTERVAL 2 DAY) ORDER by sid ASC ";
$result = mysql_query($sql, $conn);
$num= mysql_num_rows($result);
mysql_close();
$i=0;
while ($i < $num) {
$sid=mysql_result($result,$i,"sid");
$sponsor=mysql_result($result,$i,"sponsor");
$category=mysql_result($result,$i,"category");
$prizevalue=mysql_result($result,$i,"prizevalue");
$prize=mysql_result($result,$i,"prize");
$url=mysql_result($result,$i,"url");
echo "
$sponsor |
$prize |
Prize Value: $$prizevalue
|
|
";
$i++;
}
?>
|
|
|
|