include ("login.php");
$year = date('Y'); // *** Edit this varible when updating the datafeed each year! ***
$month = date('m');
if ($month > '9') { $year = $year+1; }
$url = $_SERVER['REQUEST_URI'];
$array = explode("/", $url);
$subcat2 = $array[1];
$display_subcat2 = str_replace("_"," ",$subcat2);
$subcat2 = str_replace("and","&",$subcat2);
$subcat3 = $array[2];
$display_subcat3 = str_replace("_"," ",$subcat3);
$subcat4 = $array[3];
$display_subcat4 = str_replace("_"," ",$subcat4);
$querystring = $array[1];
$cat2 = str_replace("_"," ",$subcat2);
$cat3 = str_replace("_"," ",$subcat3);
$cat4 = str_replace("_"," ",$subcat4);
$check = str_replace("page","",$subcat3);
if (is_numeric($check)) { $page = $check; }
$check2 = str_replace("page","",$subcat4);
if (is_numeric($check2)) { $page = $check2; }
?>
if ($page == "") { echo "$year Sports Calendars by Sports Pool.com. Buy the sports fanatic who has everything a $year Sports Calendar! Purchase your Christmas gifts!"; }
if ($page) { echo "Page $page - $year Sports Calendars. Buy the fan who has everything else a great Christmas Gift of Stocking Stuffer"; }
?>
|
|
|
if ($page == "") { echo "$year Sports Calendars for MLB, NBA, NFL, NHL, PGA, NASCAR teams and more"; }
if ($page) { echo "Page $page of the $year Major League Sports Calendars"; } ?>
if ($page == "") { echo "Are you looking for a $year sports calendar? Are you a sports fanatic who just cannot live without your sports memorabilia? Maybe you are looking for that perfect gift for a MLB baseball, NFL football, NHL hockey, NBA, basketball, NASCAR auto racing or golf fan. These sports calendars are not only useful, but are collectors items that any sports fan would love to own. The Calendars are newly arrived and contain some of the best moments in sports history, team histories, jokes and more. Buy a gift that your sports fan will truly love and one that will be used for the whole year! Simply click on the categories below to select a sports calendar you are interested in."; }
if ($page) { echo "Page $page - Are you looking for a $year sports calendar? $year sports calendars have just arrived! Maybe you are an avid fan or maybe you have someone in your family you want to surprise. We have the best $year sports calendars available. Sports calendars make excellent gift ideas for your fanatical fan! Simply select the calendar you are interested in from below."; }
?>
$adtype = '120x600'; include ("../includes/ads.php"); ?>
|
if ($querystring == "") {
echo "";
$count = 0;
$query = "select distinct subcat from calendars_com where category = 'Sports'";
$query2 = mysql_query($query) or die ("Unable to Select #2");
while ($query3 = mysql_fetch_array($query2)) {
$category = $query3['subcat'];
$display_category = str_replace('"',"",$category);
$categorydir = str_replace(" ","_",$category);
$categorydir = str_replace('"',"",$categorydir);
$categorydir = str_replace("&","and",$categorydir);
$count = $count + 1;
if ($count == "1") { echo ""; }
echo " | $display_category | ";
if ($count == "2") { echo " "; $count = 0; }
}
?>
} ?>
if (($subcat2) && ($subcat3 == "")) {
$query = "select count(*) from calendars_com where subcat = '$display_subcat2'";
$query2 = mysql_query($query);
$query3 = mysql_fetch_array($query2);
$num = $query3[0];
$pagenum = $num / 20;
$pagecount = 0;
if ($page == "") { $page = 1; }
if ($page) { $display_start = ($page * 20) - 19; $display_end = ($page * 20); }
$nextpage = $page + 1;
$previous = $page -1;
echo " Navigation: Home$display_subcat1 / ";
while ($pagecount < $pagenum) {
$pagecount = $pagecount + 1;
if ($pagecount != "1") {
echo "$pagecount / ";
}
$count = 1;
$query = "select * from calendars_com where subcat = '$display_subcat2'";
$query2 = mysql_query($query) or die ("Unable to Select #1");
echo "
";
while ($query3 = mysql_fetch_array($query2)) {
$count = $count + 1;
if (($count >= $display_start) && ($count <= $display_end)) {
$id = $query3['id'];
$publisher = $query3['manufacturer'];
$description = $query3['description'];
$imageurl = $query3['image_url'];
$title = $query3['title'];
$link = $query3['buy_url'];
$price = $query3['price'];
echo " Published by $publisher | $title
Product# $id Selling for $$price
$description...
| ";}
}
echo " ";
} //end id check
} //end subcat2
?>
if ($subcat3) {
$check = str_replace("page","",$subcat3);
if (!is_numeric($check)) {
$count =0;
echo "";
$query = "select distinct cat3 from calendars_categories where cat2 like '%$cat3%'";
$query2 = mysql_query($query);
while ($query3 = mysql_fetch_array($query2)) {
$count++;
$displaycat3 = $query3['cat3'];
$urlcat3 = str_replace(" ","_",$displaycat3);
echo "$displaycat3 | ";
if ($count == "2") { echo ""; $count =0; }
}
echo "
";
$query = "select distinct catid from calendars_categories where cat2 like '%$cat3%'";
$query2 = mysql_query($query);
$query3 = mysql_fetch_array($query2);
$id = $query3['catid'];
$query = "select count(*) from calendars where CategoryID = '$id'";
$query2 = mysql_query($query);
$query3 = mysql_fetch_array($query2);
$num = $query3[0];
$pagenum = $num / 20;
$pagecount = 0;
if ($page == "") { $page = 1; }
if ($page) { $display_start = ($page * 20) - 19; $display_end = ($page * 20); }
$nextpage = $page + 1;
$previous = $page -1;
echo " Navigation: Home - $display_subcat2 - $display_subcat3 ";
while ($pagecount < $pagenum) {
$pagecount = $pagecount + 1;
if ($pagecount != "1") {
echo "$pagecount ";
}
}
$count = 0;
$query = "select * from calendars_com where id = '$id'";
$query2 = mysql_query($query) or die ("Unable to Select #1");
echo "
";
while ($query3 = mysql_fetch_array($query2)) {
$count = $count + 1;
if (($count >= $display_start) && ($count <= $display_end)) {
$id = $query3['id'];
$publisher = $query3['manufacturer'];
$description = $query3['description'];
$imageurl = $query3['image_url'];
$title = $query3['title'];
$link = $query3['buy_url'];
$price = $query3['price'];
echo " Published by $publisher | $title
Product# $id Selling for $$price
$description...
| ";}
}
echo " ";
}
//end of is not numeric
if (is_numeric($check)) {
echo " Navigation: Home / $display_subcat2 /";
while ($pagecount < $pagenum) {
$pagecount = $pagecount + 1;
if ($pagecount != "1") { echo "$pagecount "; }
}
echo "
";
$query = "select * from calendars_com where id = '$subcat3'";
$query2 = mysql_query($query) or die ("Unable to Select #1");
$query3 = mysql_fetch_array($query2);
$id = $query3['id'];
$publisher = $query3['manufacturer'];
$description = $query3['description'];
$imageurl = $query3['image_url'];
$title = $query3['title'];
$link = $query3['buy_url'];
$price = $query3['price'];
echo " Published by $publisher | $title
Product# $id Selling for $$price
$description...
| ";
echo " ";
} //end of is_numeric
} //end of subcat 3 picked
?>
|
include ("footer.inc"); ?>
|
|