$dbru = "frfuncom_dbview";
$dbrp = "DB_view1";
$db = "frfuncom_charity";
$count_entries = 0;
$entries = array("25A" => "No One");
$activities=array("Start", "Start (20yds)", "Pizza (20yds free for archers)", "Pizza (free for archers)", "Pizza", "Mocktails", "Mocktails", "Disco", "Disco", "Disco", "Graveyard Shift","Graveyard Shift","Graveyard Shift","Sunrise Coffee & Free McD's", "Sunrise Coffee", "Sunrise Coffee", "TBC", "TBC", "Sponsors", "Sponsors 20yds", "Sponsors", "End & BBQ", "End", "End");
$con=mysqli_connect("",$dbru,$dbrp,$db);
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sqlEntries = "SELECT * FROM Entries";
$Entriesresult = mysqli_query($con, $sqlEntries);
while ($row = mysqli_fetch_array($Entriesresult))
{
$name = substr($row['fname'],0,1).substr($row['sname'],0,1);
$entries += [$row['time'].$row['pos'] => $name];
$count_entries = $count_entries + 1;
}
?>
 |
|
Our charity event will take place on Friday 18 July through to Saturday 19 July. Please feel free to invite friends, family and colleagues between 10:00 and 15:00 on the Saturday. Family & Friends will include Have-A-Go, Win a Robin Hood hat, Archery Tag, Feed the Dog, IceCream, BBQ a Raffle, hopefully a Mayor and other activites. If you're a Southampton Archery club Archer, you can book one or more slots below.
Pick one or more slots (30yds unless stated) below, we would hope archers would raise £25 per slot. Our Justgiving page is here. Reach out to tournaments@southamptonarcherclub.org if you have questions. |
|
Time |
Activity |
A |
B |
C |
D |
$slot=0;
$day="Fri";
while ($slot <24 ) {
$slot=$slot + 1;
if ($slot < 10) {
$day = "Fri" ;
$time = $slot+14;
$time = $time.":00";
$dtime = $slot+14;
}
else if ($slot >= 10 AND $slot < 20) {
$day = "Sat";
$time = $slot-10;
$time = "0".$time.":00";
$dtime=$slot-10;
}
else
{
$day = "Sat";
$time = $slot-10;
$time = $time.":00";
$dtime = $slot-10;
}
?>
Warning: Undefined variable $day in /home/frfuncom/public_html/charity/index.php on line 92
Warning: Undefined variable $time in /home/frfuncom/public_html/charity/index.php on line 92
|
Warning: Undefined variable $slot in /home/frfuncom/public_html/charity/index.php on line 93
Warning: Undefined variable $activities in /home/frfuncom/public_html/charity/index.php on line 93
Warning: Trying to access array offset on null in /home/frfuncom/public_html/charity/index.php on line 93
|
$cell=$dtime."A";
if (strlen($entries[$cell])>0)
{
$cell = $entries[$cell];
$class="tdnohover";
}
else
{
$cell = "select";
$class="tdhover";}
?>
Warning: Undefined variable $cell in /home/frfuncom/public_html/charity/index.php on line 106
|
$cell=$dtime."B";
if (strlen($entries[$cell])>0)
{
$cell = $entries[$cell];
$class="tdnohover";
}
else
{
$cell = "select";
$class="tdhover";}
?>
Warning: Undefined variable $cell in /home/frfuncom/public_html/charity/index.php on line 119
|
$cell=$dtime."C";
if (strlen($entries[$cell])>0)
{
$cell = $entries[$cell];
$class="tdnohover";
}
else
{
$cell = "select";
$class="tdhover";}
?>
Warning: Undefined variable $cell in /home/frfuncom/public_html/charity/index.php on line 132
|
$cell=$dtime."D";
if (strlen($entries[$cell])>0)
{
$cell = $entries[$cell];
$class="tdnohover";
}
else
{
$cell = "select";
$class="tdhover";}
?>
Warning: Undefined variable $cell in /home/frfuncom/public_html/charity/index.php on line 145
|
}
?>
Sat 15:00 |
Big Finale! |
Total entries so far:
Warning: Undefined variable $count_entries in /home/frfuncom/public_html/charity/index.php on line 154
which means around £
Warning: Undefined variable $count_entries in /home/frfuncom/public_html/charity/index.php on line 154
0 so far! |