Musky Chart Data
Hayward's oldest online Musky Chart
[linechart]
{ label: “Muskies”,
color: “#175FA9”,
data: [
show_errors();
$myfishing= $wpdbtest_otherdb->get_results(“SELECT * FROM $table $query “);
$row_cnt = $wpdbtest_otherdb->num_rows;
foreach ($myfishing as $myrecord) {
$Catch_Date =$myrecord->Catch_Date;
$dater = date(“Y”,strtotime($Catch_Date));
$Length =$myrecord->Length;
$Weather =$myrecord->Weather;
$Lure =$myrecord->Lure;
print “[$dater,$Length],”;
}
?>
] } ,
{ label: “Weather”,
color: “#17A91E”,
data: [
show_errors();
$myfishing= $wpdbtest_otherdb->get_results(“SELECT * FROM $table $query “);
$row_cnt = $wpdbtest_otherdb->num_rows;
foreach ($myfishing as $myrecord) {
$Catch_Date =$myrecord->Catch_Date;
$dater = date(“Y”,strtotime($Catch_Date));
$Length =$myrecord->Length;
$Weather =$myrecord->Weather;
$Lure =$myrecord->Lure;
print “[$dater,$Weather],”;
}
?>
] }
[/linechart]
[barchart minx=”1993″ maxx=”2021″ miny=”25″ maxy=”60″ steps=”false” fill=”false” points=”true” legend=”true”]
{ label: “Bars”,
data: [
show_errors();
$myfishing= $wpdbtest_otherdb->get_results(“SELECT * FROM $table $query “);
$row_cnt = $wpdbtest_otherdb->num_rows;
foreach ($myfishing as $myrecord) {
$Catch_Date =$myrecord->Catch_Date;
$dater = date(“Y”,strtotime($Catch_Date));
$Length =$myrecord->Length;
$Weather =$myrecord->Weather;
$Lure =$myrecord->Lure;
print “[$dater,$Length],”;
}
?>
] }[/barchart]
[piechart donut=”0.5″]
show_errors();
$myfishing= $wpdbtest_otherdb->get_results(“SELECT * FROM $table $query “);
$row_cnt = $wpdbtest_otherdb->num_rows;
foreach ($myfishing as $myrecord) {
$Catch_Date =$myrecord->Catch_Date;
$dater = date(“Y”,strtotime($Catch_Date));
$Length =$myrecord->Length;
$Weather =$myrecord->Weather;
$Lure =$myrecord->Lure;
print ” { label: \”Series1\”, data: $Weather}, “;
}
?>
[/piechart]
[barchart minx=”1992″ maxx=”2012″ miny=”8″ maxy=”125″ steps=”false” fill=”false” points=”true” legend=”true”]
{ label: “Total Fish”,
data: [show_errors();
$myfishing= $wpdbtest_otherdb->get_results(“SELECT * FROM $table LIMIT 0, 90 “);
$row_cnt = $wpdbtest_otherdb->num_rows;
foreach ($myfishing as $myrecord) {
$year =$myrecord->year;
$REG =$myrecord->REG;
print “[$year,$REG],”;
}
?>] }[/barchart]
[linechart minx=”1992″ maxx=”2012″ miny=”1″ maxy=”125″ steps=”true” fill=”false” points=”true” ]
{ label: “Muskies”,
color: “#175FA9”,
data: [
show_errors();
$myfishing= $wpdbtest_otherdb->get_results(“SELECT * FROM $table LIMIT 0, 90 “);
$row_cnt = $wpdbtest_otherdb->num_rows;
foreach ($myfishing as $myrecord) {
$year =$myrecord->year;
$REG =$myrecord->REG;
print “[$year,$REG],”;
}
?>
] }
[/linechart]