$nav = $_SERVER["REQUEST_URI"];
$script = $_SERVER["SCRIPT_NAME"];
$nav = ereg_replace("^$script", "", $nav);
$nav = str_replace('.html','',$nav);
$vars = explode("/", $nav);
$bra = $vars[1];
$bra = str_replace('%20',' ',$bra);
?>
Sporting Good Stores : from Dicks Sporting Goods, Fogdog and Sports Chalet
$hostname = "localhost";
$username = "sporting_nitro";
$password = "iucpxleps";
$dbName = "sporting_";
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
mysql_select_db("$dbName") or die("Unable to select database");?>
| Categories
|
$query = mysql_query("SELECT distinctrow primary_category FROM sports where brand_name = '$bra' ORDER BY primary_category ASC");
while ($row = mysql_fetch_array($query)) {
echo'.'.ucwords(strtolower($row["primary_category"])).' ';
}
?>
-Back to Main
|
| Brand List |
|
$query = mysql_query("SELECT * FROM list ORDER BY letter ASC");
while ($row = mysql_fetch_array($query)) {
printf ('[%s]',
$row["letter"], $row["letter"]);
}
?> |
| Miscellaneous
|
-Add Bookmark
Add Your Links
|
|
|
| Stores
|

|
|