include ("conn.php");
// Use limit of 1 with and order on the start date to get around the crossover between dec 31 and jan 01
$today_format = date("0000-m-d");
$whereclause = "li_date = '$today_format' AND li_active = 'Yes'";
$orderclause = "li_size DESC";
$sql = "SELECT * FROM listings WHERE " . $whereclause . " ORDER BY " . $orderclause . " LIMIT 10";
$result = @mysql_query($sql,$connection) or die("Couldn't execute query.");
if (mysql_num_rows($result) > 0 ) {
$ad_count = 0;
while ($row = mysql_fetch_array($result)) {
$li_id = $row['li_id'];
$li_weblink_title = $row['li_weblink_title'];
$li_weblink = $row['li_weblink'];
$li_image1 = $row['li_image1'];
$li_size = $row['li_size'];
if (($li_size > 1) && ($ad_count < 10)) {
$print_page .= "
";
$ad_count = $ad_count + $li_size;
} else {
if ((($ad_count == 0) || ($ad_count == 2) || ($ad_count == 4) || ($ad_count == 6) || ($ad_count == 8)) && ($ad_count < 10)) {
$print_page .= "";
$ad_count = $ad_count + $li_size;
} else if ($ad_count < 10) {
$print_page .= "
";
$ad_count = $ad_count + $li_size;
}
}
}
$ads_left = 10 - $ad_count;
$print_page .= "