It looks good. One suggestion though. Please... seperate the teams into different pages. Don't put them all on one big one.
Since you're allready using php, just add something like
if ( isset($HTTP_GET_VARS['tn']) || isset($HTTP_POST_VARS['tn']) )
{
$team_number = (int) ( isset(HTTP_POST_VARS['tn']) ? $HTTP_POST_VARS['tn'] : $HTTP_GET_VARS['tn'] );
if ( $team_number < 1 || $team_number > 9999 )
{
$team_number = -1;
}
} else {
$team_number = -1;
}
if ($team_number != -1)
{
$add_sql = "WHERE team_number = $team_number";
} else {
$add_sql = "";
}
Then... to your sql string that you get to fetch the data.. just go
$sql .= $add_sql
note... if you allredy have a WHERE to take that out of the $add_sql and to rename the team_number in the sql to whatever it's in your db. This should work with any version of php and if you use a new enough version you can just use the globals. Also... be sure you have magic quotes or else use addslashes($team_number) before the sql.
Also... once you finish this.. please pm or email me with a direct link to a team page so that I can add your db to the
www.feds201.com