4c4 < Team Names, Baseball, Basketball, Football, Hockey, Soccer --- > Famous Dogs and Famous Dog Names, sort 62,72c62 < <

Major Professional Team Sorted by Locale

<

From “A Game With No Rules”

<

(For individual sports listings, go to Professional Sports Team Names)

<

See also Teams Sorted by Nickame

< <

This < table shows most major professional teams for baseball, football, basketball and < hockey for the following leagues, sorted by locale. There are numerous other professional < leagues not included here; but including them is beyond the scope of this site.

< --- > 84,122c74,91 < --- > All dogs   > Dogs in books   > Real-life dogs   >
> Actual dogs on TV   > Actual dogs in movies   >
> Animated dogs on TV   > Animated dogs in movies   >
> All dogs on TV   > All dogs in movies   >
> Animated dogs on screen   > Actual dogs on screen   >
> Dogs in advertisements   > Dogs in comic   128c97 < Sort by locale --- > Sort by dog name 130c99 < Sort by team name --- > Sort by context (or title) 132,134c101 < Sort by venue <
< Sort by earliest year --- > Sort by breed 136c103 < Sort by latest year --- > Sort by earliest year 152,154c119,120 < $ihref=' $ix='Dog'; 164c130 < $dbname = 'jimwegry_Teams'; --- > $dbname = 'jimwegry_Dogs'; 171c137,138 < $result = mysql_query("SELECT llink, locale, lname, tlink, team, datein, dateout, sport, league FROM sports ORDER BY ilocale"); --- > $result = mysql_query("SELECT image, dname, n1, venue, vname, vnote, typelink, type, > tnote, years FROM Doglist ORDER BY dname"); 174,175c141,142 < $setup="All Teams"; < $col="lname"; --- > $setup="All Dogs"; > $col="dname"; 180c147 < if ($col=='lname') --- > if ($col=='vname') 182,183c149,150 < $sort="Sorted by Locale"; < $result = mysql_query("SELECT llink, locale, lname, tlink, team, datein, dateout, sport, league FROM sports ORDER BY ilocale"); --- > $sort="Sorted by Context (or Title)"; > $result = mysql_query("SELECT image, dname, n1, venue, vname, vnote, typelink, type, tnote, years FROM Doglist ORDER BY vname"); 186c153 < elseif ($col=='team') --- > elseif ($col=='type') 188,189c155,156 < $sort="Sorted by Team Name"; < $result = mysql_query("SELECT llink, locale, lname, tlink, team, datein, dateout, sport, league FROM sports ORDER BY iteam"); --- > $sort="Sorted by Breed"; > $result = mysql_query("SELECT image, dname, n1, venue, vname, vnote, typelink, type, tnote, years FROM Doglist ORDER BY type"); 192c159 < elseif ($col=='datein') --- > elseif ($col=='date') 195,201c162 < $result = mysql_query("SELECT llink, locale, lname, tlink, team, datein, dateout, sport, league FROM sports ORDER BY idatein"); < mysql_close(); < } < elseif ($col=='dateout') < { < $sort="Sorted by Earliest Year"; < $result = mysql_query("SELECT llink, locale, lname, tlink, team, datein, dateout, sport, league FROM sports ORDER BY idateout"); --- > $result = mysql_query("SELECT image, dname, n1, venue, vname, vnote, typelink, type, tnote, years, date FROM Doglist ORDER BY date"); 206,207c167,168 < $sort="Sorted by League"; < $result = mysql_query("SELECT llink, locale, lname, tlink, team, datein, dateout, sport, league FROM sports ORDER BY ileague"); --- > $sort="Sorted by Dog Name"; > $result = mysql_query("SELECT image, dname, n1, venue, vname, vnote, typelink, type, tnote, years FROM Doglist ORDER BY dname"); 211c172 < $setup="All Teams"; --- > $setup="All Dogs"; 230,236c191,195 < echo '

Locale

'; < echo '

Team Name

'; < echo '

Venue

'; < echo '

Dates

'; < echo '

League

'; < < $result = mysql_query($sql) or die(mysql_error()); --- > echo '

Image

'; > echo '

Dog Name

'; > echo '

Context (or Title)

'; > echo '

Dog Breed

'; > echo '

Years

'; 239c198 < { --- > { 247c206 < if ((strpos($row['league'],"the movie")) || (strpos($row['venue'],"the TV"))) --- > if ((strpos($row['venue'],"the movie")) || (strpos($row['venue'],"the TV"))) 252c211 < if (strpos($row['league'],$pup)) --- > if (strpos($row['venue'],$pup)) 256c215 < if (strpos($row['league'],$pup)) --- > if (strpos($row['years'],$pup)) 260c219 < if ((strpos($setup,"ctual")) && (strpos($row['league'],"uppet"))) --- > if ((strpos($setup,"ctual")) && (strpos($row['vnote'],"uppet"))) 266c225 < if (strpos($row['lname'],"z

")) --- > if (strpos($row['vname'],"z

")) 268c227 < ($row['lname']="

"); --- > ($row['vname']="

"); 274,278c233,236 < echo $pp.$row['llname'].$td; < echo $ihrefwiki.$row['tlink'].$iy.$row['team'].''.$td; < echo $ihref.$row['llick'].$iy.$row['locale'].''.$td; < echo $row['datein']."-".$row['dateout'].$td; < echo $row['league'].'

'; --- > echo $pp.$ix.$row['image'].$iy.$td.$row['dname'].$row['n1'].$td; > echo $row['venue'].$row['vname'].$row['vnote'].$td; > echo $row['typelink'].$row['type'].$row['tnote'].$td; > echo $row['years']."

"; 281c239 < echo "

The number of teams in this listing is ".$count.""; --- > echo "

The number of dogs in this listing is ".$count.""; 315c273 < --- > \ No newline at end of file