Master Naturalist Hours Summary

die (‘Can\’t use foo : ‘ . mysql_error());
}

$query = “SELECT sub_id FROM wp_formidabledata WHERE field_name=’Email’ AND field_val='”.$_POST[‘myotis_field_1’].”‘”;
//echo “$query
“;
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
//echo “Name: “.$row[‘field_val’].”
“;

$query = “SELECT field_val FROM wp_formidabledata 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 ”
$query = “SELECT DISTINCT sub_id FROM wp_formidabledata WHERE field_name=’Email’ AND field_val='”.$_POST[‘myotis_field_1’].”‘”;
//echo “$query”;
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
//echo $row[‘sub_id’];$query2 = “SELECT field_val FROM wp_formidabledata 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

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

“;

//create the details table

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

echo ”

“; echo “”;
$query = “SELECT DISTINCT sub_id FROM wp_formidabledata WHERE field_name=’Email’ AND field_val='”.$_POST[‘myotis_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_formidabledata WHERE field_name=’Date of Volunteer Activity or Continuing Education’ 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_formidabledata 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_formidabledata 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_formidabledata 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 ”

Date Hours What You Did Supervisor

“;
?>