Master Naturalist Hours Summary

“;
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
//echo “Name: “.$row[‘field_val’].”
“;

$query = “SELECT field_val FROM wp_cformsdata WHERE sub_id='”.$row[‘sub_id’].”‘ AND field_name=’Name’ LIMIT 0,1″;
//echo “$query
“;
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

echo “

“;
echo “

“;
echo “

“;
echo “

Name: “.$row[‘field_val’].”
Email: “.$_POST[‘cf7_field_1’].”
Total Hours: “;

$query = “SELECT DISTINCT sub_id FROM wp_cformsdata WHERE field_name=’Email’ AND field_val='”.$_POST[‘cf7_field_1’].”‘”;
//echo “$query”;
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
//echo $row[‘sub_id’];

$query2 = “SELECT field_val FROM wp_cformsdata WHERE field_name=’Volunteer Hours Worked’ AND sub_id='”.$row[‘sub_id’].”‘”;
//echo “$query2”;
$result2 = mysql_query($query2);
while ($row = mysql_fetch_assoc($result2)) {
$total_hours += $row[‘field_val’];
}
}
echo “$total_hours

“;

//create the details table

$main_bg_color = ‘#DCD6C8’;
$alt_bg_color = ‘#FFFFFF’;

echo “

“;
echo “

“;
$query = “SELECT DISTINCT sub_id FROM wp_cformsdata WHERE field_name=’Email’ AND field_val='”.$_POST[‘cf7_field_1’].”‘”;
//echo “$query”;
$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
$row_count++;
if (($row_count % 2)) $bg_color = $main_bg_color;
//echo $row[‘sub_id’];
echo “

“;

//Date
$query2 = “SELECT field_val FROM wp_cformsdata WHERE field_name=’Date of Volunteer Activity’ AND sub_id='”.$row[‘sub_id’].”‘”;
//echo “$query2”;
$result2 = mysql_query($query2);
$row2 = mysql_fetch_assoc($result2);
echo “

“;

//hours
$query3 = “SELECT field_val FROM wp_cformsdata WHERE field_name=’Volunteer Hours Worked’ AND sub_id='”.$row[‘sub_id’].”‘”;
//echo “$query2”;
$result3 = mysql_query($query3);
$row3 = mysql_fetch_assoc($result3);
echo “

“;

//Location
$query4 = “SELECT field_val FROM wp_cformsdata WHERE field_name=’Where You Worked and What You Did’ AND sub_id='”.$row[‘sub_id’].”‘”;
//echo “$query2”;
$result4 = mysql_query($query4);
$row4 = mysql_fetch_assoc($result4);
echo “

“;

//Supervisor
$query5 = “SELECT field_val FROM wp_cformsdata WHERE field_name=’Supervisor Name’ AND sub_id='”.$row[‘sub_id’].”‘”;
//echo “$query5”;
$result5 = mysql_query($query5);
$row5 = mysql_fetch_assoc($result5);
echo “

“;

echo “

“;
}
echo “

Date Hours Location Supervisor
“.$row2[‘field_val’].” “.$row3[‘field_val’].” “.$row4[‘field_val’].” “.$row5[‘field_val’].”

“;
?>