I'm suffering eye fatique, and after reading the code for the maybe millionth of time, I still can't figure out what I'm doing wrong in this one.
Ideally, you get to this registration form by clicking on a link in a previous page, so the registration form automatically enters in the event name. The registrant then fills in the information. When you click on submit, you should be getting the "thank you" screen, but instead, it's being redirected back to the previous page, the events listings page. I'm sure I'm missing something but I cant figure out what it is. The email form code is from Aitsh (as indicated) and is shown here: <?php // Checks to see if there's an selected event ID if (!$sel_eventID) { header("Location: index_test.php"); exit; } // connects to database include("../admin/cnx_db.inc"); // set up a query where there's a match for the event_ID $sql = "SELECT * FROM events WHERE event_ID='$sel_eventID'"; // perform query and get results $sql_result = mysql_query($sql); if (!$sql_result) { echo "Can't execute $sql " . mysql_error(); exit; } else { $row = mysql_fetch_array($sql_result); $id = $row["event_ID"]; $esc_title = $row["TITLE"]; $esc_date = $row["DATE"]; $esc_city = $row["CITY"]; $esc_province = $row["PROVINCE"]; $esc_fee = $row["FEE"]; // strips out formatting slashes $title = stripslashes($esc_title); $date = stripslashes($esc_date); $city = stripslashes($esc_city); $province = stripslashes($esc_province); $fee = stripslashes($esc_fee); } // Disconnects from database and free up resources include("../admin/byebye.inc"); // the following is the Form Email Script. // written by Aitsh // /*************************************************************************** ******** * script : aitsh mail * version : 1.0b * author : advanced it services holland * email : [EMAIL PROTECTED] * date : 10/10/1999 (original : 08/07/1999) * country : the netherlands, europe * copyright : you are free to modify this script, as long as you keep this header in your script. * description : a dynamic mail-script * comments : simple to set-up and to configure/adjust it * installation : edit the vars below and your ready !!! [after uploading :-)] * things to do : automatic reply to visitor, better documentation inside the script, and more... * things done : added 'required' fields **************************************************************************** *******/ /* if no recipient is given, mail should go this address */ $no_recipient = "specialneedslaw"; /* if a user doesn't enter an email-address, use this address instead (if not defined as a required field) */ $no_email = "[EMAIL PROTECTED]"; /* if a user doesn't enter a subject, use this subject instead (if not defined as a required field)*/ $no_subject = "Events Registration submitted from website"; /* if a user doesn't enter a name, use this name instead [if not defined as a required field] */ $no_contact_person = "No Name Brand"; /* your company name */ $company_name = "The Canadian Legal Network for Children with Special Needs"; /* $page_title : the title of your mail pages */ $page_title = "Registration Form for Event Registration"; /* domain name */ $domain = "lmlweb.com"; /* the filename of your script */ $scriptname = "register.php"; /* the form fields you want to be required */ $required = array("fname","lname","address","city","province","areacode","phone"); /* say yes if your mail-agent can handle html-mail, else say no NOTE: always a good idea to keep the default set to no to keep it usable - not all mail browsers can handle HTML */ $html_mail = "no"; /* if the mail.php?to= has a predefined value, change the 'to: name' */ if($recipient == "info") { $recipientname = "$company_name Info"; } elseif($recipient == "webmaster") { $recipientname = "$company_name Webmaster"; } else { $recipientname = "$company_name"; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> <html lang="en-us"><!-- #BeginTemplate "/Templates/forms_pages.dwt" --> <head> <!-- #BeginEditable "doctitle" --> <title>Register for an Event</title> <!-- #EndEditable --> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="../styles.css" type="text/css"> <script language="JavaScript" src="http://specialneedslaw.lmlweb.com/includes/breadcrumb.js" type="text/javascript"> </script> </head> <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <table cellspacing="0" cellpadding="0" width="720"> <tr> <td rowspan="3" width="81" height="85" align="right"><img src="../gfx/logo.gif" width="81" height="85" alt="The Canadian Legal Network for Children with Special Needs"></td> <td width="1"><img src="../gfx/spacer.gif" width="1" height="35" alt=" "></td> <td align="right" width="638"><a href="../index.html"><img src="../gfx/urlgif.gif" width="134" height="22" alt="www.specialneedslaw.ca" border="0"></a></td> </tr> <tr> <td colspan="2" bgcolor="#FFF2E5" align="left"><img src="../gfx/logotype.gif" width="559" height="25" alt=" "></td> </tr> <tr> <td width="1"> </td> <td align="right" width="638"> </td> </tr> </table> <table cellspacing="5" cellpadding="0" width="720"> <tr> <td> <script language="JavaScript" type="text/javascript"> <!-- begin hide breadCrumbs('specialneedslaw.lmlweb.com','<img src="http://specialneedslaw.lmlweb.com/gfx/bread_arrow.gif" alt=">" >','index.html','Breadcrumb','BreadcrumbTitle','None','0'); // end hide --> </script><noscript class="Breadcrumb"><a href="../index.html">Home</a></noscript> </td> <td align="right"> <span class="DateStamp"> <?php include("http://specialneedslaw.lmlweb.com/includes/today.inc") ?> </span></td> </tr> </table> <table border="0" cellpadding="0" cellspacing="8" width="720" > <tr> <td width="20%" valign="top"> <!-- #BeginLibraryItem "/Library/leftnav.lbi" --><div class="LeftNav"> <p class="NavCategory"><a href="../index.html" class="NavCategory">Home</a></p><p class="NavCategory"><a href="../about_us/index.html" class="NavCategory">About Us</a></p><p class="LeftNavText">> <a href="../about_us/index.html">About Us</a></p><p class="LeftNavText">> <a href="../about_us/contact_us.html">Contact Us</a></p><p class="NavCategory"><a href="../legal_resources/index.html" class="NavCategory">Legal Resources</a></p><p class="LeftNavText">> <a href="../legal_resources/legal_cases/index.html">Legal Cases</a></p><p class="LeftNavText">> <a href="../legal_resources/international_law/intl_law.html">International Law</a></p><p class="LeftNavText">> <a href="../legal_resources/lawyer_ref.html">Need a Lawyer or Advocate?</a></p><p class="NavCategory"><a href="../health_resources/index.html" class="NavCategory">Health Resources</a></p><p class="LeftNavText">> <a href="../health_resources/index.html">Health Resources</a></p><p class="NavCategory"><a href="../special_education/index.html" class="NavCategory">Special Education</a></p><p class="LeftNavText">> <a href="../special_education/index.html">Special Education</a></p><p class="NavCategory"><a href="index.html" class="NavCategory">Events</a></p><p class="LeftNavText">> <a href="index.html">Events</a> </p><p class="NavCategory"><a href="../other_links/index.html" class="NavCategory"> Links</a></p><p class="LeftNavText">> <a href="../other_links/index.html">Links</a></p></div><!-- #EndLibraryItem --> <!--<FORM method=get ACTION="/cgi-bin/webglimpse/home/laurie/lmlweb-www"> <div class="BlueBox"> <p class="BoxBoxTitle">Search This Site</p> <p class="BlueBoxText" align="center"> <INPUT NAME=query size=15> <br> <input type="image" name="Submit" src="../gfx/searchbutton.gif" width="43" height="27" border=0> </p> </div> </form> --> </td> <td valign="top" width="80%"> <h1 class="ContentTitle"><!-- #BeginEditable "Content Title" -->Registration Form <!-- #EndEditable --></h1> <img src="../gfx/orange_spacer.gif" height="1" alt="--------------" align="left" width="100%"><br> <!-- #BeginEditable "Content" --> <? // first part of mail script if($action == "send") { $reset = reset($required); while (list($key, $value) = each($required)) { if($form[$value] == "") { $count++; } } if($count > 0) { ?> <form action="<?php echo $scriptname; ?>?action=send" METHOD="POST"> <h2> <input type="HIDDEN" name="recipient" value="<?php echo $recipient; ?>"> All fields marked with an asterisk (<font color="#FF6600">*</font>) must be filled in before the events details can be submitted. Please make sure you've filled in all of the required fields below. </h2> <table cellspacing="2"> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>First Name:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[fname]" value="<?php echo $form[fname]; ?>" size="35"> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>Last Name:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[lname]" value="<?php echo $form[lname]; ?>" size="35"> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>Address:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[address]" value="<?php echo $form[address]; ?>" size="35"> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>City:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[city]" value="<?php echo $form[city]; ?>" size="35"> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>Province/State:</p> </td> <td align="LEFT" > <select name="form[province]"><option value="<?php echo $form[province]; ?>" selected> <?php echo $form[province]; ?> </option> <option value="">- Select Province/State -</option> <option value="Alberta">Alberta</option> <option value="British Columbia">British Columbia</option> <option value="Manitoba">Manitoba</option> <option value="New Brunswick">New Brunswick</option> <option value="Newfoundland">Newfoundland</option> <option value="Northwest Territories">Northwest Territories</option> <option value="Nunavut">Nunavut</option> <option value="Nova Scotia">Nova Scotia</option> <option value="Ontario">Ontario</option> <option value="Prince Edward Island">Prince Edward Island</option> <option value="Quebec">Quebec</option> <option value="Saskatchewan">Saskatchewan</option> <option value="Yukon">Yukon</option> <option value="">-----</option> <option value="Alabama">Alabama</option> <option value="Alaska">Alaska</option> <option value="Arizona">Arizona</option> <option value="Arkansas">Arkansas</option> <option value="California">California</option> <option value="Colorado">Colorado</option> <option value="Connecticut">Connecticut</option> <option value="Delaware">Delaware</option> <option value="Florida">Florida</option> <option value="Georgia">Georgia</option> <option value="Hawaii">Hawaii</option> <option value="Idaho">Idaho</option> <option value="Illinois">Illinois</option> <option value="Indiana">Indiana</option> <option value="Iowa">Iowa</option> <option value="Kansas">Kansas</option> <option value="Kentucky">Kentucky</option> <option value="Louisiana">Louisiana</option> <option value="Maine">Maine</option> <option value="Maryland">Maryland</option> <option value="Massachusetts">Massachusetts</option> <option value="Michigan">Michigan</option> <option value="Minnesota">Minnesota</option> <option value="Mississippi">Mississippi</option> <option value="Missouri">Missouri</option> <option value="Montana">Montana</option> <option value="Nebraska">Nebraska</option> <option value="Nevada">Nevada</option> <option value="New Hampshire">New Hampshire</option> <option value="New Jersey">New Jersey</option> <option value="New Mexico">New Mexico</option> <option value="New York">New York</option> <option value="North Carolina">North Carolina</option> <option value="North Dakota">North Dakota</option> <option value="Ohio">Ohio</option> <option value="Oklahoma">Oklahoma</option> <option value="Oregon">Oregon</option> <option value="Pennsylvania">Pennsylvania</option> <option value="Puerto Rico">Puerto Rico</option> <option value="Rhode Island">Rhode Island</option> <option value="South Carolina">South Carolina</option> <option value="South Dakota">South Dakota</option> <option value="Tennessee">Tennessee</option> <option value="Texas">Texas</option> <option value="Utah">Utah</option> <option value="Vermont">Vermont</option> <option value="Virginia">Virginia</option> <option value="Washington">Washington</option> <option value="Washington DC">Washington D.C.</option> <option value="West Virginia">West Virginia</option> <option value="Wisconsin">Wisconsin</option> <option value="Wyoming">Wyoming</option> <option value="Other">Other</option> </select> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>Phone: </p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[areacode]" value="<?php echo $form[areacode]; ?>" size="3"> <input type="TEXT" name="form[phone]" value="<?php echo $form[phone]; ?>" size="8"> </td> </tr> <tr> <td align="LEFT"> <p>Email:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[email]" value="<?php echo $form[email]; ?>" size="35"> </td> </tr> <tr align="CENTER"> <td colspan="2"> <input type="SUBMIT" value="Submit" name="SUBMIT2"> <input type="RESET" value="Reset" name="RESET2"> </td> </tr> </table> <p> </p> </form> <? } else { if(!$form[email]) { $form[email] = "$no_email"; } if(!$form[contact_person]) { $form[contact_person] = "$no_contact_person"; } if(!$form[subject]) { $form[subject] = "$no_subject";} $final_recipient = "$recipient@$domain"; /* following is for html formatting - ignore unless you want to create an html-formatted email */ if($html_mail == "yes") { mail("$recipientname <$final_recipient>","$form[subject]","<html><!-- nothing here, not using HTML formatted emails in this case. --></html>", "From: $form[contact_person] <$form[email]>\nReply-To: $form[contact_person] <$form[email]>\nContent-type: text/html\nX-Mailer: PHP/" . phpversion()); /* end of html formatted email set up */ } else { /* the real meat of the email form */ mail("$recipientname <$final_recipient>","$form[subject]","$form[fname] ($form[lname]) sent the following Events Registration Form for $title to $recipientname ($final_recipient) : \n\n Name: $form[fname] $form[lname] \n Address: $form[address] \n $form[city] $form[province] \n Phone: $form[areacode] $form[phone] \n\n","From: $form[fname] $form[lname] <$form[email]>\nReply-To: $form[contact_person] <$form[email]>\nContent-type: text/plain\nX-Mailer: PHP/" . phpversion()); } ?> <div align="center"> <h2>Thank you</h2> <p>Your events registration will be send immediately to </p> <p><b>Canadian Legal Network for Children with Special Needs.</b></p> <p>You will receive a confirmation email as soon as possible.</p> </div> <? } } else { if($to == "") { $recipient = "$no_recipient"; } else { $recipient = $to; } ?> <p class="topmargin">To register for this event, <b><?php echo $title ?></b>, please fill out the form below.</p> <p class="topmargin">Alternatively, you can contact us by e-mail or telephone us at (add number)</p> <p><b><?php echo $title ?></b></p> <form action="<?php echo $scriptname; ?>?action=send" METHOD="POST"> <input type="HIDDEN" name="recipient" value="<?php echo $recipient; ?>"> <table cellspacing="2"> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>First Name:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[fname]" size="35"> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>Last Name:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[lname]" size="35"> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>Address:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[address]" size="35"> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>City:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[city]" size="35"> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>Province/State:</p> </td> <td align="LEFT" > <select name="form[province]"> <option value="" selected>- Select Province/State -</option> <option value="Alberta">Alberta</option> <option value="British Columbia">British Columbia</option> <option value="Manitoba">Manitoba</option> <option value="New Brunswick">New Brunswick</option> <option value="Newfoundland">Newfoundland</option> <option value="Northwest Territories">Northwest Territories</option> <option value="Nunavut">Nunavut</option> <option value="Nova Scotia">Nova Scotia</option> <option value="Ontario">Ontario</option> <option value="Prince Edward Island">Prince Edward Island</option> <option value="Quebec">Quebec</option> <option value="Saskatchewan">Saskatchewan</option> <option value="Yukon">Yukon</option> <option value="">-----</option> <option value="Alabama">Alabama</option> <option value="Alaska">Alaska</option> <option value="Arizona">Arizona</option> <option value="Arkansas">Arkansas</option> <option value="California">California</option> <option value="Colorado">Colorado</option> <option value="Connecticut">Connecticut</option> <option value="Delaware">Delaware</option> <option value="Florida">Florida</option> <option value="Georgia">Georgia</option> <option value="Hawaii">Hawaii</option> <option value="Idaho">Idaho</option> <option value="Illinois">Illinois</option> <option value="Indiana">Indiana</option> <option value="Iowa">Iowa</option> <option value="Kansas">Kansas</option> <option value="Kentucky">Kentucky</option> <option value="Louisiana">Louisiana</option> <option value="Maine">Maine</option> <option value="Maryland">Maryland</option> <option value="Massachusetts">Massachusetts</option> <option value="Michigan">Michigan</option> <option value="Minnesota">Minnesota</option> <option value="Mississippi">Mississippi</option> <option value="Missouri">Missouri</option> <option value="Montana">Montana</option> <option value="Nebraska">Nebraska</option> <option value="Nevada">Nevada</option> <option value="New Hampshire">New Hampshire</option> <option value="New Jersey">New Jersey</option> <option value="New Mexico">New Mexico</option> <option value="New York">New York</option> <option value="North Carolina">North Carolina</option> <option value="North Dakota">North Dakota</option> <option value="Ohio">Ohio</option> <option value="Oklahoma">Oklahoma</option> <option value="Oregon">Oregon</option> <option value="Pennsylvania">Pennsylvania</option> <option value="Puerto Rico">Puerto Rico</option> <option value="Rhode Island">Rhode Island</option> <option value="South Carolina">South Carolina</option> <option value="South Dakota">South Dakota</option> <option value="Tennessee">Tennessee</option> <option value="Texas">Texas</option> <option value="Utah">Utah</option> <option value="Vermont">Vermont</option> <option value="Virginia">Virginia</option> <option value="Washington">Washington</option> <option value="Washington DC">Washington D.C.</option> <option value="West Virginia">West Virginia</option> <option value="Wisconsin">Wisconsin</option> <option value="Wyoming">Wyoming</option> <option value="Other">Other</option> </select> </td> </tr> <tr> <td align="LEFT"> <p><font color="#FF6600">*</font>Phone: </p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[areacode]" size="3"> <input type="TEXT" name="form[phone]" size="8"> </td> </tr> <tr> <td align="LEFT"> <p>Email:</p> </td> <td align="LEFT" nowrap> <input type="TEXT" name="form[email]" size="35"> </td> </tr> <tr align="CENTER"> <td colspan="2"> <input type="SUBMIT" value="Submit"> <input type="RESET" value="Reset"> </td> </tr> </table> </form> <? } ?> <!-- #EndEditable --></td> </tr> <tr align="center"> <td colspan="2"> <p class="Content"><a href="../about/index.html">About Us</a> | <a href="../legal_notes.html">Legal Notes</a> | <a href="../about/contact_us.html">Contact Us</a> | <a href="../webmaster.html">Problems?</a></p> </td> </tr> </table> </body> <!-- #EndTemplate --></html> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php