UKSMG Summer Marathon Table

UKSMG Marathon World Standings

Click to select another regional table: World | AN | AF | AS | EU | NA | SA | OC | My Grid List
  
'N/A' AND date between '$summer_test_start' AND '$summer_test_end' GROUP BY oper ORDER BY Score DESC, best_qrb DESC;"; $query = "SELECT oper, mylo, DATE_FORMAT(MAX(date),'%e%-%b%-%Y') AS date_last_qso, COUNT(DISTINCT(grid)) AS Score, MAX(dist) AS best_qrb FROM $test_table WHERE loca <> 'N/A' AND date between '$summer_test_start' AND '$summer_test_end' GROUP BY oper ORDER BY Score DESC, best_qrb DESC;"; $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['oper']) { echo "\n"; } else { if ($mnum2 % 2) { echo "\n"; } else { echo "\n"; } } // echo ""; echo ""; $mnum2 = $mnum2 + 1; $mnum = $mnum + 1; } mysql_free_result($result); ?>
Pos View Callsign Grid Score Best QRB (Km) Last QSO
".$mnum2."
".strtoupper($row['oper'])." ".strtoupper($row['mylo'])."".$row['Score']."".$row['best_qrb']."".$row['date_last_qso']."
".$mnum2."
".strtoupper($row['oper'])." ".substr($row['mylo'],0,4)."".$row['Score']."".$row['best_qrb']."".$row['date_last_qso']."