SELECT teampage.*, schools.school, schools.auto as school_id, schools.forum_id, schools.allnews FROM teampage INNER JOIN schools ON teampage.team = schools.Auto where team = #teamid# SELECT * FROM themenu <cfoutput>#teamstuff.pagetitle#</cfoutput>
#teamstuff.flipad#
  Displaying All Teams Information  
       
  Seach:   Click here to Search just #teamstuff.school#  
 
 
 
Click Here to Search ALL TEAMS