Climbing permit system data

Choose a query from the "Menu" above
'$year-01-01' AND date<'$year-12-31' ORDER BY date ASC"; $r=mysqli_query($con,$s); while($rows=mysqli_fetch_array($r)){ ?>
# Date Route Size Summit Leader Zip Code
Total Climbers:

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: '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,&chxr=1,8500,"/>