|
";
} else {
echo "SportsMoz.org is the first place you should look for your favorite sports related websites. With over " . number_format($num) . " sports links, SportsMoz is the internets most complete sports directory service. It does not matter if you are looking for NFL. PGA, NHL, MLB, NBA, NCAA, Olympics, Archery or even Gaelic sports resources you will find all the related sports website links here. If you have a sports related website and you would like to be listed in the internets most complete sports directory service simply select the submit url button below! All we request is that you link back to us if you like what you see here."; }
?>
|
SportsMoz is currently listing " . number_format($num) . " sports websites!";
?>
|
";
$query = "SELECT cat,count FROM categories order by cat asc";
$query2 = mysql_query($query) or die ("broken");
while ($query3 = mysql_fetch_array($query2)) {
$eachcat = $query3['cat'];
$eachcatcount = $query3['count'];
if ($count == "0") { echo ""; }
$count = $count + 1;
$temp2 = str_replace("_"," ","$eachcat");
echo " | $temp2
($eachcatcount Resources) | ";
if ($count == "4") { echo " "; $count = 0; }
}
echo " ";
}
# ---------------------------------------------Sub Cat 2---------------------------------------------
if (($subcat2) && ($subcat3 == "")) {
echo "Resources / $display_subcat2
";
$count = 0;
echo "";
$query = "SELECT DISTINCT subcat3 FROM `links` where subcat2 = '$subcat2' order by subcat3 asc";
$query2 = mysql_query($query) or die ("broken1");
while ($query3 = mysql_fetch_array($query2)) {
$display_subcat3 = $query3['subcat3'];
if ($count == "0") { echo ""; }
if ($display_subcat3) {
$count = $count + 1;
$temp2 = str_replace("_"," ","$display_subcat3");
echo " | $temp2
(Resources) | ";
}
if ($count == "3") { echo " "; $count = 0; }
}
echo " ";
//using url in the query below cause it should be the smallest.
$query = "SELECT url FROM `links` where subcat2 = '$subcat2' and subcat3 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
$temp = mysql_fetch_array($query2);
if ($temp) { echo "
";
?>
$display_subcat2 Links
"; }
$query = "SELECT title,url,description FROM `links` where subcat2 = '$subcat2' and subcat3 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
while ($query3 = mysql_fetch_array($query2)) {
$title = $query3['title'];
$url = $query3['url'];
$desc = $query3['description'];
if (($title !== "") && ($url !== "") && ($desc !== "")) {
echo " | ";
}
}
if ($temp) { echo " "; }
// Displays our link partners
mysql_pconnect("localhost","indemand","T0utjaca1") or die("Unable to connect to SQL server");
mysql_select_db("links") or die("Unable to select database");
$display="no";
$query = "select title,url,description from links where domainname = 'sportsmoz.org' and category = '$subcat2'";
$query2 = mysql_query($query);
while ($query3 = mysql_fetch_array($query2)) {
$title = $query3['title'];
$url = $query3['url'];
$desc = $query3['description'];
if (($title !== "") && ($url !== "") && ($desc !== "")) {
if ($display == "no") { echo "
Sportsmoz Partners
"; $display = "yes"; }
echo " | ";
} }
include ("login.php");
}
# ---------------------------------------------Sub Cat 3---------------------------------------------
if (($subcat3) && ($subcat4 == "")) {
echo "Resources / $display_subcat2 / $display_subcat3
";
$count = 0;
echo "";
$query = "SELECT DISTINCT subcat4 FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' order by subcat4 asc";
$query2 = mysql_query($query) or die ("broken1");
while ($query3 = mysql_fetch_array($query2)) {
$display_subcat4 = $query3['subcat4'];
if ($count == "0") { echo ""; }
if ($display_subcat4) {
$count = $count + 1;
$temp2 = str_replace("_"," ","$display_subcat4");
echo " | $temp2
(Resources) | ";
}
if ($count == "3") { echo " "; $count = 0; }
}
echo " ";
$query = "SELECT url FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
$temp = mysql_fetch_array($query2);
if ($temp) { echo "
";
?>
$display_subcat3 Links"; }
$query = "SELECT title,url,description FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
while ($query3 = mysql_fetch_array($query2)) {
$title = $query3['title'];
$url = $query3['url'];
$desc = $query3['description'];
if (($title !== "") && ($url !== "") && ($desc !== "")) {
echo " | ";
}
}
if ($temp) { echo " "; }
}
# ---------------------------------------------Sub Cat 4---------------------------------------------
if (($subcat4) && ($subcat5 == "")) {
echo "Resources / $display_subcat2 / $display_subcat3 / $display_subcat4
";
$count = 0;
echo "";
$query = "SELECT DISTINCT subcat5 FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' order by subcat5 asc";
$query2 = mysql_query($query) or die ("broken1");
while ($query3 = mysql_fetch_array($query2)) {
$display_subcat5 = $query3['subcat5'];
if ($count == "0") { echo ""; }
if ($display_subcat5) {
$count = $count + 1;
$temp2 = str_replace("_"," ","$display_subcat5");
echo " | $temp2
(Resources) | ";
}
if ($count == "3") { echo " "; $count = 0; }
}
echo " ";
$query = "SELECT url FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
$temp = mysql_fetch_array($query2);
if ($temp) { echo "
";
?>
$display_subcat4 Links"; }
$query = "SELECT title,url,description FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
while ($query3 = mysql_fetch_array($query2)) {
$title = $query3['title'];
$url = $query3['url'];
$desc = $query3['description'];
if (($title !== "") && ($url !== "") && ($desc !== "")) {
echo " | ";
}
}
if ($temp) { echo " "; }
}
# ---------------------------------------------Sub Cat 5---------------------------------------------
if (($subcat5) && ($subcat6 == "")) {
echo "Resources / $display_subcat2 / $display_subcat3 / $display_subcat4 / $display_subcat5
";
$count = 0;
echo "";
$query = "SELECT DISTINCT subcat6 FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '$subcat5' order by subcat6 asc";
$query2 = mysql_query($query) or die ("broken1");
while ($query3 = mysql_fetch_array($query2)) {
$display_subcat6 = $query3['subcat6'];
if ($count == "0") { echo ""; }
if ($display_subcat6) {
$count = $count + 1;
$temp2 = str_replace("_"," ","$display_subcat6");
echo " | $temp2
(Resources) | ";
}
if ($count == "3") { echo " "; $count = 0; }
}
echo " ";
$query = "SELECT url FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '$subcat5' and subcat6 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
$temp = mysql_fetch_array($query2);
if ($temp) { echo "
";
?>
$display_subcat5 Links"; }
$query = "SELECT title,url,description FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '$subcat5' and subcat6 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
while ($query3 = mysql_fetch_array($query2)) {
$title = $query3['title'];
$url = $query3['url'];
$desc = $query3['description'];
if (($title !== "") && ($url !== "") && ($desc !== "")) {
echo " | ";
}
}
if ($temp) { echo " "; }
}
# ---------------------------------------------Sub Cat 6---------------------------------------------
if (($subcat6) && ($subcat7 == "")) {
echo "
$subcat2 / $display_subcat3 / $display_subcat4 / $display_subcat5
/ $display_subcat6";
$count = 0;
echo "";
$query = "SELECT DISTINCT subcat7 FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '$subcat5' and subcat6 = '$subcat6' order by subcat7 asc";
$query2 = mysql_query($query) or die ("broken1");
while ($query3 = mysql_fetch_array($query2)) {
$display_subcat7 = $query3['subcat7'];
if ($count == "0") { echo ""; }
if ($display_subcat7) {
$count = $count + 1;
$temp2 = str_replace("_"," ","$display_subcat7");
echo " | $temp2
(Resources) | ";
}
if ($count == "3") { echo " "; $count = 0; }
}
echo " ";
$query = "SELECT url FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '$subcat5' and subcat6 = '$subcat6' and subcat7 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
$temp = mysql_fetch_array($query2);
if ($temp) { echo "
";
?>
$display_subcat6 Links"; }
$query = "SELECT title,url,description FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '$subcat5' and subcat6 = '$subcat6' and subcat7 = '' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
while ($query3 = mysql_fetch_array($query2)) {
$title = $query3['title'];
$url = $query3['url'];
$desc = $query3['description'];
if (($title !== "") && ($url !== "") && ($desc !== "")) {
echo " | ";
}
}
if ($temp) { echo " "; }
}
# ---------------------------------------------Sub Cat 7---------------------------------------------
if ($subcat7) {
echo "Resources /
$subcat2 / $display_subcat3 / $display_subcat4 / $display_subcat5
/ $display_subcat6
/ $display_subcat7
";
$count = 0;
?>
$display_subcat7 Links";
$query = "SELECT title,url,description FROM `links` where subcat2 = '$subcat2' and subcat3 = '$subcat3' and subcat4 = '$subcat4' and subcat5 = '$subcat5' and subcat6 = '$subcat6' and subcat7 = '$subcat7' order by title asc";
$query2 = mysql_query($query) or die ("broken2");
while ($query3 = mysql_fetch_array($query2)) {
$title = $query3['title'];
$url = $query3['url'];
$desc = $query3['description'];
if (($title !== "") && ($url !== "") && ($desc !== "")) {
echo " | ";
}
}
echo " ";
}
echo "
";
?>
Featured Directory:
Feature 1 |";
$rand = rand(2,1652);
$query = "SELECT url FROM directories where num = '$rand'";
$query2 = mysql_query($query) or die("Select two Failed!");
$query3 = mysql_fetch_array($query2);
$url = $query3['url'];
echo " Feature 2 |";
$rand = rand(2,1652);
$query = "SELECT url FROM directories where num = '$rand'";
$query2 = mysql_query($query) or die("Select two Failed!");
$query3 = mysql_fetch_array($query2);
$url = $query3['url'];
echo " Feature 3 |
";
?>
|
|
|
|
