|
|
//####################################
//News
//####################################
$itemType = 1;
$numresults=mysql_query("select * FROM t_items where type_id = $itemType");
$numrows=mysql_num_rows($numresults);
$result = mysql_query("SELECT item_id,
short_desc,
date_format(item_date,'%d-%m-%y') as itemDate,
full_desc
FROM t_items
where type_id = $itemType order by item_date desc, item_id desc limit 5");
if (!$result)
{
echo("Error performing query: " . mysql_error() . " ");
exit();
}
if ($numrows == 0)
{
?>
| |
No news items available |
}
else
{
while ( $row = mysql_fetch_array($result))
{
$item_id = $row["item_id"];
$short_desc = $row["short_desc"];
$item_date = $row["itemDate"];
$full_desc = $row["full_desc"];
?>
| echo ($item_date); ?> |
|
}
}
?>
|
| Notice Board |
//####################################
//Notice Board
//####################################
$itemType = 2;
$numresults=mysql_query("select * FROM t_items where type_id = $itemType");
$numrows=mysql_num_rows($numresults);
$result = mysql_query("SELECT item_id,
short_desc,
date_format(item_date,'%d-%m-%y') as itemDate,
full_desc
FROM t_items
where type_id = $itemType order by item_date desc, item_id desc limit 5");
if ($numrows == 0)
{
?>
| |
No notice board items available |
}
else
{
while ( $row = mysql_fetch_array($result))
{
$item_id = $row["item_id"];
$short_desc = $row["short_desc"];
$item_date = $row["itemDate"];
$full_desc = $row["full_desc"];
?>
| echo($item_date); ?> |
|
}
}
?>
|
| Results |
 |
|
//####################################
//Results
//####################################
$itemType = 4;
$numresults=mysql_query("select * FROM t_results_fixtures where type_id = $itemType");
$numrows=mysql_num_rows($numresults);
$sql = "SELECT result_fixture_id,
date_format(result_fixture_date,'%d-%m-%y') as rfDate,
competition_desc,grade_desc,sex,score
FROM t_results_fixtures rf, t_competitions c, t_grades g
WHERE rf.grade_id = g.grade_id
AND rf.competition_id = c.competition_id
AND rf.type_id = $itemType
ORDER BY result_fixture_date desc limit 5";
$result = mysql_query($sql);
if (!$result) {
echo("Error performing query: " . mysql_error() . " ");
exit();
}
if ($numrows == 0) {
?>
| |
No results available |
}
else {
while ( $row = mysql_fetch_array($result)) {
$rfId = $row["result_fixture_id"];
$result_fixture_date = $row["rfDate"];
$score = $row["score"];
$other = $row["grade_desc"] . " (" . $row["sex"] . ") ";
?>
| echo($result_fixture_date); ?> |
|
}
}
?>
|
| Fixtures |
//####################################
//Fixtures
//####################################
$itemType = 3;
$numresults=mysql_query("select * FROM t_results_fixtures where type_id = $itemType");
$numrows=mysql_num_rows($numresults);
$sql = "SELECT result_fixture_id,
date_format(result_fixture_date,'%d-%m-%y') as rfDate,
competition_desc,grade_desc,sex,opposition_desc
FROM t_results_fixtures rf, t_competitions c, t_grades g, t_oppositions o
WHERE rf.grade_id = g.grade_id
AND rf.competition_id = c.competition_id
AND rf.opposition_id = o.opposition_id
AND rf.type_id = $itemType
AND result_fixture_date >= now()
ORDER BY result_fixture_date limit 10";
$result = mysql_query($sql);
if (!$result) {
echo("Error performing query: " . mysql_error() . " ");
exit();
}
if ($numrows == 0) {
?>
| |
No fixtures available |
}
else
{
while ( $row = mysql_fetch_array($result))
{
$rfId = $row["result_fixture_id"];
$result_fixture_date = $row["rfDate"];
$other = $row["grade_desc"] . " (" . $row["sex"] . ") " . $row["competition_desc"];
$opposition = "V " . $row["opposition_desc"];
?>
| echo($result_fixture_date); ?> |
|
}
}
?>
|