We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
$matchID = mysql_real_escape_string($_REQUEST['id']); mysql_select_db($database_db, $db); $query_history = "SELECT *, date_format(matches.date, '%W %D %M %Y') as mDate FROM matches LEFT JOIN matchscores ON matches.match_id = matchscores.match_id LEFT JOIN team ON team.team_id = matchscores.team LEFT JOIN referee ON referee.ref_id = matches.referee_id LEFT JOIN venue ON venue.venue_id = matches.venue_id WHERE matches.match_id = $matchID"; $history = mysql_query($query_history, $db) or die(mysql_error()); $row_history = mysql_fetch_assoc($history); $totalRows_history = mysql_num_rows($history); mysql_select_db($database_db, $db); $query_enable_login = "SELECT disable_login FROM season"; $enable_login = mysql_query($query_enable_login, $db) or die(mysql_error()); $row_enable_login = mysql_fetch_assoc($enable_login); $totalRows_enable_login = mysql_num_rows($enable_login); mysql_select_db($database_db, $db); $query_match_fixtures = "select m.match_id, date_format(m.date, '%d/%m/%Y') as mDate, m.time, t1.division, m.report, t1.team_name as team1_name, s1.score as score1, t2.team_name as team2_name, s2.score as score2 from matches m left join (matchscores s1 left join team t1 on t1.team_id = s1.team) on (s1.match_id = m.match_id) left join (matchscores s2 left join team t2 on t2.team_id = s2.team) on (s2.match_id = m.match_id) where s1.team <> s2.team AND m.match_id = $matchID group by match_id order by m.match_id"; $match_fixtures = mysql_query($query_match_fixtures, $db) or die(mysql_error()); $row_match_fixtures = mysql_fetch_assoc($match_fixtures); $totalRows_match_fixtures = mysql_num_rows($match_fixtures); mysql_select_db($database_db, $db); $query_match_player = "SELECT * FROM match_player LEFT JOIN player on player.player_id = match_player.player_id LEFT JOIN team ON player.team_id = team.team_id WHERE match_id = $matchID AND team.team_name = '$row_match_fixtures[team1_name]'"; $match_player = mysql_query($query_match_player, $db) or die(mysql_error()); $row_match_player = mysql_fetch_assoc($match_player); $totalRows_match_player = mysql_num_rows($match_player);
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.