Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
Elements	[ DIR ]	drwxr-sr-x	2014-07-04 12:09
Scripts	[ DIR ]	drwxr-sr-x	2014-07-04 12:14
css	[ DIR ]	drwxr-sr-x	2014-07-04 12:06
fckeditor	[ DIR ]	drwxr-sr-x	2014-07-04 12:12
images	[ DIR ]	drwxrwsr-x	2020-06-06 16:04
img	[ DIR ]	drwxr-sr-x	2019-07-18 14:37
include	[ DIR ]	drwxr-sr-x	2020-06-06 16:06
js	[ DIR ]	drwxr-sr-x	2014-07-04 12:14
thumbs	[ DIR ]	drwxr-sr-x	2014-07-04 12:10
08_29_2011_CESA_Relay_2011_Offcial_Results.xls	183.5 KB	-rw-r--r--	2014-07-04 12:06
09_03_2012_Summary_Results_CESA_Relay_20120825.xlsx	78.13 KB	-rw-r--r--	2014-07-04 12:06
10km Cycle Route.pdf	222.98 KB	-rw-r--r--	2016-08-29 08:38
2009RelayPrizeWinners.zip	22.49 KB	-rw-r--r--	2014-07-04 12:06
2009RelayResults.zip	79.71 KB	-rw-r--r--	2014-07-04 12:07
5km Run Route.pdf	220.07 KB	-rw-r--r--	2016-08-29 08:38
Binder1.pdf	1.64 MB	-rw-r--r--	2014-08-19 08:47
CESA 2018 Cycle Route.pdf	1.03 MB	-rw-r--r--	2018-08-26 10:29
CESA 2018 Run Route.pdf	965.48 KB	-rw-r--r--	2018-08-26 10:29
CESA Relay Map.pdf	440.13 KB	-rw-r--r--	2014-08-20 09:07
CESA Relay.docx	855.17 KB	-rw-r--r--	2014-07-03 09:45
CESA Venue Layout.pdf	408.39 KB	-rw-r--r--	2014-08-20 09:08
CESA2018Results.pdf	19.62 KB	-rw-r--r--	2018-09-26 09:59
CESA_Relay_Order_Form.xls	57.5 KB	-rw-r--r--	2016-07-27 13:49
CESA_Relay_Order_Form.xlsx	28.42 KB	-rw-r--r--	2016-07-20 08:24
CESA_relay_results.xls	214.5 KB	-rw-r--r--	2014-07-04 12:07
Cycling Route.pdf	998.8 KB	-rw-r--r--	2017-08-23 08:23
Kyalami Country Club - Platter list.doc	24.5 KB	-rw-r--r--	2016-08-02 08:15
Relay_2008_Results.zip	56.99 KB	-rw-r--r--	2014-07-04 12:09
Relay_2008_Results_CSV.zip	22.05 KB	-rw-r--r--	2014-07-04 12:09
Running Route.pdf	936.87 KB	-rw-r--r--	2017-08-23 08:23
Summary_Results_CESA_Relay_2013.pdf	141.26 KB	-rw-r--r--	2014-07-04 12:09
add.php	9.44 KB	-rw-r--r--	2014-07-04 12:07
addimg.php	994 B	-rw-r--r--	2014-07-04 12:07
addimgck.php	2.83 KB	-rw-r--r--	2014-07-04 12:07
comp_cyc.php	2.84 KB	-rw-r--r--	2014-07-04 12:07
error_log	11.04 KB	-rw-r--r--	2014-07-04 12:09
gallery.php	2.79 KB	-rw-r--r--	2017-09-27 09:06
index.php	4.79 KB	-rw-r--r--	2020-02-12 09:53
kcc_drinks_order.pdf	108.71 KB	-rw-r--r--	2016-08-12 12:08
mailer.html	2.35 KB	-rw-r--r--	2016-06-22 09:15
mailer2.html	2.53 KB	-rw-r--r--	2016-08-24 08:45
mailer3.html	3.18 KB	-rw-r--r--	2016-08-24 08:50
readme.txt	241 B	-rw-r--r--	2014-07-04 12:09
screen.css	2.96 KB	-rw-r--r--	2016-06-22 08:10

Rename

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
$bgcnt=1;
	
		$link = mysql_connect('localhost','ssidhvcc_matthew','shareb');
  		if ($link) {
    	$db=mysql_select_db('ssidhvcc_ssisite');
    		if (db) {
    	   echo("Server connection established - generating report");
    		} 
  		 }

// retrieve data
//SELECT ID_num, name FROM saace_teammembers WHERE ID_num < 7900000000000 AND ID_num LIKE '______5______'"
$result1 = mysql_query("SELECT * FROM saace_team WHERE type='3' AND team_type='Comp' ORDER BY 'type'");

echo "<table border='1' cellspacing='0' cellpadding='0'><br />
	<tr><h1> Competative Cycle Teams </h1></tr>
	<tr>
	<th style='text-align:left;'>Team Name</th>
	<th style='text-align:left;'>Team Type</th>
	<th style='text-align:left;'>Type</th>
	<th style='text-align:left;'>Company ID</th>
	</tr>";
	
	while($row = mysql_fetch_array($result1))
	  {
	  if ($row['name'] != NULL){
	   echo "<tr";
                  if ($bgcnt%2==0) {
                    echo " class='odd'";
                  } else {
                    echo " class='even'";
                  }
                  echo ">\n";
	  //echo "<td width='150px;'>" .$row['ID_num']. "</td>";
	  echo "<td width='150px;'>" . $row['name'] . "</td>";
	  echo "<td width='150px;'>" . $row['type'] . "</td>";
	  echo "<td width='150px;'>" . $row['team_type'] . "</td>";
	  echo "<td width='150px;'>" . $row['id'] . "</td>";
 	  echo "</tr>";
	  $bgcnt++;
	  }
	  }
	  
	  $result1 = mysql_query("SELECT * FROM saace_teammembers ORDER BY team_id");

echo "<table border='1' cellspacing='0' cellpadding='0'><br />
	<tr><h1> Rec Walking Teams </h1></tr>
	<tr>
	<th style='text-align:left;'>Team ID</th>
	<th style='text-align:left;'>Name</th>
	<th style='text-align:left;'>Surname</th>
	<th style='text-align:left;'>ID</th>
	<th style='text-align:left;'>Gender</th>
	<th style='text-align:left;'>Date of Birth</th>
	</tr>";
	
	while($row = mysql_fetch_array($result1))
	  {
	  if ($row['name'] != NULL){
	   echo "<tr";
                  if ($bgcnt%2==0) {
                    echo " class='odd'";
                  } else {
                    echo " class='even'";
                  }
                  echo ">\n";
	  //echo "<td width='150px;'>" .$row['ID_num']. "</td>";
	  echo "<td width='150px;'>" . $row['team_id'] . "</td>";
	  echo "<td width='150px;'>" . $row['name'] . "</td>";
	  echo "<td width='150px;'>" . $row['surname'] . "</td>";
	  echo "<td width='150px;'>" . $row['ID_num'] . "</td>";
	  echo "<td width='150px;'>" . $row['gender'] . "</td>";
	  echo "<td width='150px;'>" . $row['age'] . "</td>";
 	  echo "</tr>";
	  $bgcnt++;
	  }
	  }
	  
	  
?> 
</body>
</html>