rendered paste bodyif ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "addMemberForm")) {
$insertSQL = sprintf("INSERT INTO members (first_name, middle_name, last_name, email, b_date, notes) VALUES (%s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['first_name'], "text"),
GetSQLValueString($_POST['middle_name'], "text"),
GetSQLValueString($_POST['last_name'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['b_date'], "date"),
GetSQLValueString($_POST['notes'], "text"));
mysql_select_db($database_Monqiboy, $Monqiboy);
$Result1 = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
$_SESSION['last_memberId'] = mysql_insert_id();
}
// add address to member:
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "addressForm")) {
$insertSQL = sprintf("INSERT INTO members_addresses (member_id, street, apt_unit, zip) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['member_id'], "int"),
GetSQLValueString($_POST['street'], "text"),
GetSQLValueString($_POST['apt_unit'], "text"),
GetSQLValueString($_POST['zip'], "double"));
mysql_select_db($database_Monqiboy, $Monqiboy);
$Result1 = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
}
.
.
.
THEN
$colname_Recordset1 = "-1";
if (isset($_SESSION['member_id'])) {
$colname_Recordset1 = $_SESSION['member_id'];
}
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_Rs_memberAddr = sprintf("SELECT members_addresses.*, citystatezip.stateAb, citystatezip.city, citystatezip.state FROM (members_addresses LEFT JOIN citystatezip ON citystatezip.zip=members_addresses.zip) WHERE member_id = %s", GetSQLValueString($colname_Recordset1, "int"));
$query_limit_Rs_memberAddr = sprintf("%s LIMIT %d, %d", $query_Rs_memberAddr, $startRow_Rs_memberAddr, $maxRows_Rs_memberAddr);
$Rs_memberAddr = mysql_query($query_limit_Rs_memberAddr, $Monqiboy) or die(mysql_error());
$row_Rs_memberAddr = mysql_fetch_assoc($Rs_memberAddr);