Print Membership CARD

SEARCH:

Enter Your Last Name::
Enter your 7-digit USSA # (without the region code letter!): */?>

If your information is not accurate please contact[email protected]. You may print a card if you want to carry proof of membership, otherwise if your race registration is correct - the race administrator will have run your USSA # and should already know if you're renewed with USSA and VARA.


SEARCH RESULTS:
These names and renewals should be accurate as of: 6/1/2020 (expiration date)
Competitors: If you notice that your DOB or your USSA # is wrong, please contact:[email protected]

*HIGHLIGHTED RED ROW = Renewal Required real_escape_string(trim($_POST['title'])); $query=$mysqli->query("SELECT *,max(i.Date) as RegTime, max(np.ProgShortName) as ProgShortName,pc.PCLID AS PCLID FROM playerclub pc LEFT OUTER JOIN player p ON pc.PID = p.PID LEFT OUTER JOIN invoice i ON i.PCLID = pc.PCLID LEFT JOIN newprogram np ON pc.ProgID = np.ProgID LEFT JOIN reganswers r ON pc.PCLID = r.PCLID AND r.RQID = 636 LEFT OUTER JOIN school s ON s.SchID = pc.SchID LEFT OUTER JOIN snowClubs sc ON sc.scLong = s.SchNm WHERE pc.CLID = 1501 AND PLNm LIKE '".$LastName."%' AND pc.PCLID IN (SELECT max(PCLID) FROM playerclub WHERE CLID = 1501 GROUP BY PID) GROUP BY p.PID ORDER BY PLNm, PFNm, pc.PCLID DESC, i.Date DESC"); while ($f = $query->fetch_array()) { if(strtotime($f['RegTime']) > strtotime('One Year Ago')){ $f['type']='renewed'; }else{ $f['type']='not-renewed'; } $my_class='bgcolor="#E7E7E7"'; $my_class1='gray'; $my_class2=''; $z=fmod($i, 2); if ($z==0) {$my_class="";}; if ($f['type']=='not-renewed') {$my_class='bgcolor="#990000"'; $my_class1='whitebold'; $my_class2=' style="color:#FFF"';} else { //$s = explode('/', $f['rdate']); //$f['rdate'] = $s[0].'/'.$s[1].'/'.date("Y"); }; $getUSSAmaster = $mysqli->query("SELECT max(ra.RegQuestionAnswerText) as USSA FROM playerclub pc LEFT OUTER JOIN reganswers ra ON ra.RQID = 636 AND ra.PCLID = pc.PCLID WHERE PID = '".$f['PID']."' GROUP BY PID"); while($USSAa = $getUSSAmaster->fetch_array()) { $USSAmaster = $USSAa['USSA']; } if($f['RegQuestionAnswerText'] == ''){ $f['RegQuestionAnswerText'] = $USSAmaster['USSA']; } ?>
CREATE CARD First Name Last Name DOB Class Renewed USSA# Club
1969 1969-12-31