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 “
Name: |
“.$row[‘field_val’].” |
“;
echo “
Email: |
“.$_POST[‘cf7_field_1’].” |
“;
echo “
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 “
Date |
Hours |
Location |
Supervisor |
“;
$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 “
“.$row2[‘field_val’].” |
“;
//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 “
“.$row3[‘field_val’].” |
“;
//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 “
“.$row4[‘field_val’].” |
“;
//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 “
“.$row5[‘field_val’].” |
“;
echo “
“;
}
echo “
“;
?>