the first Books recordset is set to filter on the recID querystring variable, the second recordset is set to filter on a column from the first recordset.
like I said initially:
this is indeed the case.
edit the forms action so it passes the recID querystring variable on submitting the form
change:
<form class="NewFromBlank_Default" id="SimpleContact_NewFromBlank_Default" name="SimpleContact_NewFromBlank_Default" method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?>">
to:
<form class="NewFromBlank_Default" id="SimpleContact_NewFromBlank_Default" name="SimpleContact_NewFromBlank_Default" method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?><?php echo (isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] != "")?"?".htmlspecialchars($_SERVER["QUERY_STRING"]):""; ?>">
Made the change -- still no e-mail. . .
Jason -- does your form code pass the recID string? teacherEmail is not directly referenced from the recID. That is why I filtered the $row_teachers recordset with the recID. That way the $row_teachers recordset contains only the record for the teacher that added the book id'ed by the recID.