include $_SERVER['DOCUMENT_ROOT']. '/scripts/dbconnect.php'; include $_SERVER['DOCUMENT_ROOT']. '/class2.php'; // require_once(HEADERF); // The following must be updated with the current Marathon data. include $_SERVER['DOCUMENT_ROOT']. '/inc/marathon_conf.php'; Global $currentUser; $user_name = $currentUser['user_loginname']; $user_call = strtoupper($user_name); $user_region = $currentUser['user_region']; $user_grid = $currentUser['user_locator']; $oper_id = USERID; if (USER) { ?> UKSMG Marathon Grid List 'N/A' AND date between '$summer_test_start' AND '$summer_test_end' AND oper_region='$user_region' GROUP BY grid ORDER BY grid ASC"; $result = mysql_query($query) or die("Query failed"); $numofrows = mysql_num_rows($result); $mnum = 1; $mnum2 = 1; for($i=0; $i < $numofrows; $i++) { $row = mysql_fetch_array($result); if ($user_call == $row["callsign"]) { echo "\n"; } else { if ($mnum2 % 2) { echo "\n"; } else { echo "\n"; } } $string = $row['DateUpdated']; $stringArray = explode("-", $string); $string = $row['dateupdated']; $stringArray = explode("-", $string); $date = mktime(0,0,0,$stringArray[1],$stringArray[2],$stringArray[0]); $convertedDate2 = date("d-m-y", $date); echo ""; $mnum2 = $mnum2 + 1; $mnum = $mnum + 1; } mysql_free_result($result); mysql_close(); } else { echo '

Marathon View Grids Error

'; echo '
'; echo 'You must be logged in to view your Grid List, please use the link below to login:'; echo '
[ Login Page ]'; echo '
'; echo '
'; echo 'If you are not a registered user of this site, please register now using the link below:'; echo '
[ Signup Page ]'; echo '
Note: user registration is moderated, you will be notified via email when your user account is ready.'; echo '
'; } ?>
No Grids
".$mnum2."".$row['grid']."