All pastes #915948 Raw Edit

Unnamed

public text v1 · immutable
#915948 ·published 2008-02-24 05:40 UTC
rendered paste body
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();
}


// 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);