LAST name is required"; if ($pwd == "" && $mem_num == "") $message = "Either PASSWORD or MEMBER NUMBER are required"; IF ($agree == "") $message = "You must check the 'Agreement' box"; if ($message != "") { //There is an error $iter = ""; } else{ // this is where we take action on the login form entries include("open_db.php"); IF ($mem_num != "") { $sTmpQuery = "SELECT * FROM members WHERE lname LIKE '".$lname."%' AND mem_num = ".$mem_num; } ELSE { $sTmpQuery = "SELECT * FROM members WHERE lname LIKE '".$lname."%' AND password = '".$pwd."'"; } $result = mysql_query($sTmpQuery); $num_rows = mysql_num_rows($result); IF ($num_rows != "1"){ $message = "
INVALID LOGIN
"; $iter = ""; } else { //They are valid...give them a member cookie and record their acceptance of soft copy $row = mysql_fetch_array($result); setCookie("MSMTAMember",$row["ID"]."|".$row["access_type"]."|".$row["fname"], time()+3600000,"/",".msmta.org"); $date = date("Y-m-d"); $sUpdate = "UPDATE members SET last_login = '".$date."', soft_copy = 1 where ID = ".$row["ID"]; $result = mysql_query($sUpdate); // header("Location: /"); } mysql_close($con); } } ?> MSMTA - Register for online content only
MSMTA Members Paper-free Correspondence Request
By completing this form, you are requesting receipt of ONLY on-line or electronic copy of future materials. This includes MSMTA newsletters and the Student Activities Handbook.
If you change your mind at a future date, you can opt back in via the "Edit My Record" link on the main menu.
 
Last Name:
Password:
           - OR -
MTNA Member Number:
By checking this box and clicking the button below, you are agreeing to receive future "mass mailing" from MSMTA in electronic-only format.
CANCEL - I want paper after all
 
If you have forgotten your password, or your MTNA member number does not work,contact THE WEBMASTER for help.
Thank you. You are helping to save paper and expenses for the MSMTA. Return to MSMTA Home