Multiple Key Columns in update function

What would be the most efficient method for having multiple Key Columns to identify which records to update?

The goal is to update records where:

Key Column 1 = Value 1 AND Key Column 2 = Value 2




EXAMPLE CODE WITH SINGLE KEY COLUMN (ID = $_SESSION['ID']):

<?php
// WA Application Builder Update
if ("" == "") // Trigger
{
$WA_connection = $upn_admin_connect;
$WA_table = "upn_admin_listing_upload";
$WA_redirectURL = "";
$WA_keepQueryString = false;
$WA_indexField = "ID";
$WA_fieldNamesStr = "property_status";
$WA_fieldValuesStr = "".$_SESSION['property_status'] ."";
$WA_columnTypesStr = "',none,''";
$WA_comparisonStr = "=";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);

$WA_where_fieldValuesStr = "".$_SESSION['ID'] ."";
$WA_where_columnTypesStr = "',none,''";
$WA_where_comparisonStr = "=";
$WA_where_fieldNames = explode("|", $WA_indexField);
$WA_where_fieldValues = explode("|", $WA_where_fieldValuesStr);
$WA_where_columns = explode("|", $WA_where_columnTypesStr);
$WA_where_comparisons = explode("|", $WA_where_comparisonStr);

$WA_connectionDB = $database_upn_admin_connect;
mysql_select_db($WA_connectionDB, $WA_connection);
if (!session_id()) session_start();
$updateParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WhereObj = WA_AB_generateWhereClause($WA_where_fieldNames, $WA_where_columns, $WA_where_fieldValues, $WA_where_comparisons );
$WA_Sql = "UPDATE `" . $WA_table . "` SET " . $updateParamsObj->WA_setValues . " WHERE " . $WhereObj->sqlWhereClause . "";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?>

DataAssist will not work with multiple key columns.


If your key column is set correctly, there should not be a need to have more than one key column.


The Idea behind a Primary Key Column is to use the AUTO INCREMENT function of the Database to assign a unique number to each record that is inserted. Since the value in the primary key column is unique for each record, you do not need to use multiple key columns to identify the record to update, just use the Primary key column.