include '../../headers/header2007.php'; include '../../baseball/mysql_connect.php'; $link = mysql_connect ($db_hostname, $db_username, $db_password); if (!$link) { die ("Couldn't connect to mySQL server 1"); } if (!mysql_select_db ($db_name, $link) ) { die ("Couldn't open error follows $db_name: ".mysql_error() ); } $team_query = "SELECT * FROM yearly_results order by season desc"; $team_result = mysql_db_query ($db_name, $team_query, $link); $thisyear_coach = "Paul Mainieri"; $thisyear_season = "2013"; $inseason = 1; $wins_w_query = "SELECT * FROM 2013_schedules where sec='LSU' and WL='W'"; $wins_query_result = mysql_db_query ($db_name, $wins_w_query, $link); $overall_wins = mysql_numrows($wins_query_result); $sec_wins_query = "SELECT * FROM 2013_schedules where sec='LSU' and WL='W' and conf='y'"; $sec_wins_query_result = mysql_db_query ($db_name, $sec_wins_query, $link); $sec_wins = mysql_numrows($sec_wins_query_result); $losses_w_query = "SELECT * FROM 2013_schedules where sec='LSU' and WL='L'"; $losses_query_result = mysql_db_query ($db_name, $losses_w_query, $link); $overall_losses = mysql_numrows($losses_query_result); $sec_losses_query = "SELECT * FROM 2013_schedules where sec='LSU' and WL='L' and conf='y'"; $sec_losses_query_result = mysql_db_query ($db_name, $sec_losses_query, $link); $sec_losses = mysql_numrows($sec_losses_query_result); ?>
Season | Overall | SEC | Coach | Tournament |
$thisyear_season | \n"; print "$overall_wins-$overall_losses | \n"; print "$sec_wins-$sec_losses | \n"; print "$thisyear_coach | \n"; print "\n"; print " |
$season | \n"; print "$overW-$overL | \n"; print "$secW-$secL | \n"; print "$coach | \n"; print "$tournament | \n"; print "