’2005-04-01′ AND DATE < ’2006-01-01′ ORDER BY Date”);
print “
\n
| Date |
\n
Opponent |
\n
h/a |
\n
Start |
\n
Type |
\n
\n”;
while ($a_row = mysql_fetch_row($allfixtures))
{
print “
\n”;
foreach ($a_row as $field)
switch ($field)
{
case “1″:
print “
1st XI |
\n”;
break;
case “2″:
print “
2nd XI |
\n”;
break;
case “3″:
print “
Friendly |
\n”;
break;
case “4″:
print “
3 Counties League |
\n”;
break;
case “5″:
print “
Under 11′s |
\n”;
break;
case “6″:
print “
Under 13′s |
\n”;
break;
case “7″:
print “
Under 15′s |
\n”;
break;
case (date(“Y”, $field) == “2004″):
$mydate=date(“jS M”, $field);
print “
$mydate |
\n”;
break;
case (date(“Y”, $field) == “2005″):
$mydate=date(“jS M”, $field);
print “
$mydate |
\n”;
break;
case “C”:
print “
Cancelled |
\n”;
break;
default:
print “
$field |
\n”;
break;
}
print “
\n”;
}
print “
\n”;
?>