Climbing permit system data
Choose a query from the "Menu" aboveif($_GET['type']=='allData'){ ?>
# | Date | Route | Size | Summit | Leader Zip Code |
---|---|---|---|---|---|
echo $rownums; ?> | echo date('F', strtotime($rows['date'])).' ', date('j', strtotime($rows['date'])).', ', date('Y', strtotime($rows['date'])); ?> | echo $rows['route']; ?> | echo $rows['size']; $totalclimbers=$totalclimbers+$rows['size']; ?> | echo $rows['summit']; ?> | echo $rows['zip']; ?> | $rownums++; ?>
Total Climbers: | echo $totalclimbers; ?> |
Total Climbers Mt. Rainier 2006-2015
'2005' GROUP BY YEAR(date) ORDER BY YEAR(date) ASC"; $qr=mysqli_query($con,$q); $str="|"; while($r=mysqli_fetch_array($qr)){ if($r['year']!=''){ $str.=$r['year']; $str.="|"; } } $str=substr($str,0,-1); echo $str; ?> &chd=t: $q="SELECT YEAR(date) as year, SUM(size) as total FROM moraclimbing WHERE YEAR(date)>'2005' GROUP BY YEAR(date) ORDER BY YEAR(date) ASC"; $max=0; $str=''; $qr=mysqli_query($con,$q); while($r=mysqli_fetch_array($qr)){ if($r['total']!=''){ $str.=$r['total']; $str.=","; if($r['total']>$max){$max=$r['total'];} } } $str=substr($str, 0, -1); echo $str; ?> &chxt=x,y&chds=8500, echo $max; ?>&chxr=1,8500, echo $max; ?>"/>} ?>