Schedule
& Results for echo $ageclass; ?> echo $name; ?>
Matchnr |
|
Date
& Time |
|
Place |
|
Home
team |
|
Away team |
|
Match type |
|
Result |
$bb_news_hostname = "localhost";
$bb_news_mysqluser = "a0046601";
$bb_news_mysqlpassword = "z6gviHm6";
$bb_news_db = "a0046600_innodb1";
mysql_connect($bb_news_hostname,$bb_news_mysqluser,$bb_news_mysqlpassword)
or die("Unable to connect to SQL server");
$query = "SELECT matchnr, ageclass, groupnr, date_format(play_date, '%Y-%c-%d %H:%i ') as play_date, play_day,
hometeam, awayteam, arena, goals_home, goals_away, final_type, matchtype,
is_final FROM matches where ageclass = '$ageclass' and final_type = '$final_type' and is_final='y' order by play_date";
$matches = mysql_db_query($bb_news_db, $query) or die("Error in getting matches. Please contact webmaster ASAP!");
while ( $row = mysql_fetch_array($matches) )
{ ?>
echo $row[matchnr]; ?> |
|
echo $row[play_date]; ?> |
|
echo $row[arena]; ?> |
|
echo $row[hometeam]; ?> |
- |
echo $row[awayteam]; ?> |
|
echo $row[matchtype]; ?> |
|
echo $row[goals_home]; ?> - echo $row[goals_away];
?> |
}
?>
Please report
any errors to webmaster, using this form