if ((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(); } . . . 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);