Let's Manipulate the Data

ID Date How Rough was the Day (3=bad)
connect_error) {die("Connection failed: " . $conn->connect_error);} // get mysql data and enter it into table $requested = "select id, date(date), how_rough from $table order by id"; //the select criteria $dataresult = $conn->query($requested); //tell the connection to run the select criteria //$data = $dataresult->fetch_assoc(); //return array of row values into $data from the connection if ($dataresult->num_rows > 0) { // output data of each row into table on left while($row = $dataresult->fetch_assoc()) { echo ''; echo ''; echo ''; echo ''; echo '';} } else {echo "0 results";} ?>
'. $row['id'] .''. $row['date(date)'] .''. $row['how_rough'] .'
query($harsh); if ($harshresult->num_rows > 0){ while($bad = $harshresult->fetch_assoc()) {echo '';$sum=$sum+$bad['count(*)'];} echo ''; } //end of if $cnt = "select how_rough, count(*) from $table group by how_rough"; //sets javascript variables to populate canvas chart $cntresult = $conn->query($cnt); while($rows = $cntresult->fetch_assoc()){ echo ''; // set barht = count of how rough for each bar } $conn->close(); ?>
For How Rough value = '.$bad['how_rough']. ''. $bad['count(*)']. ' days.
total entries to date'. $sum. '


";?> Return to aka.net