Passing List/Menu Records to Update Page Using PHP and Dreamweaver

<?php
$tfmsqlstr = "";
if (isset($_POST["searchID"]) || isset($_GET["searchID"])){
  $tfm_searchField = (isset($_POST["searchID"]))?$_POST["searchID"]:$_GET["searchID"];
  if($tfm_searchField != "") {
    $tfm_andor = "AND";
    $tfm_exact = "false";
    $bellChar = chr(7);
    $tfmsqlstr = " WHERE ((";
    $tfm_databaseFields = explode(",","lastName,quoteDate,firstName,phone,phoneAlt,address,city,state,zip,email,stockNumberOld,tradeYear,tradeMake,tradeModel,lienholder,acctNum,payoffAmt,tradeACV,oldPayment,stockNumberNew,quotedMake,quotedModel,quotedYear,newPayment,paymentDiff,followUpLetterNotes,followUpCallNotes,apptScheduledNotes,notes,custID");    
    if ((strstr($tfm_searchField,'"')) || ($tfm_exact == "true")){ 
       $tfm_searchField = str_replace('"','',$tfm_searchField); 
       $tfm_andor = "OR";
    }else 
    if (stristr($tfm_searchField," or ")){ 
      $tfm_searchField = preg_replace('/\s+or\s+/i',$bellChar,$tfm_searchField);
      $tfm_andor = "OR";
    }else  
    if (strstr($tfm_searchField,',') || strstr($tfm_searchField,' ') || stristr(strtolower($tfm_searchField),' and ')) { 
      $tfm_searchField = preg_replace("/\s+and\s+/i",$bellChar,$tfm_searchField);
      $tfm_searchField = str_replace(",",$bellChar,$tfm_searchField);
      $tfm_searchField = str_replace(" ",$bellChar,$tfm_searchField);
    }
    $splitField = explode($bellChar,$tfm_searchField);
    for ($i = 0; $i < sizeof($splitField) ;$i++){
      for ($j = 0; $j < sizeof($tfm_databaseFields); $j++){
        $tfmsqlstr = $tfmsqlstr."(".$tfm_databaseFields[$j]." LIKE '%".str_replace("'","''",$splitField[$i])."%')"; 
        if ($j < sizeof($tfm_databaseFields)-1) $tfmsqlstr = $tfmsqlstr." OR "; 
      }
      if ($i < sizeof($splitField) -1) $tfmsqlstr = $tfmsqlstr.") ".$tfm_andor." (";
    }
    $tfmsqlstr = $tfmsqlstr."))";
  }else{
    $tfmsqlstr = " WHERE 1=1 ";
  }
}else{
  $tfmsqlstr = " WHERE 1=1 ";
}
?>
<?php require_once('../../Connections/mydatabase.php'); ?>
<?php
$tfm_orderby =(!isset($_GET["tfm_orderby"]))?"custID":$_GET["tfm_orderby"];
$tfm_order =(!isset($_GET["tfm_order"]))?"ASC":$_GET["tfm_order"];
$sql_orderby = " " .$tfm_orderby." ".$tfm_order;
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
if (isset($_POST['lastName']) && !empty($_POST['lastName'])) {
  session_start();
    $_SESSION['salutation'] = $_POST['salutation'];
	$_SESSION['lastName'] = $_POST['lastName'];
	$_SESSION['firstName'] = $_POST['firstName'];
	$_SESSION['quotedYear'] = $_POST['quotedYear'];
	$_SESSION['quotedModel'] = $_POST['quotedModel'];
	$_SESSION['newPayment'] = $_POST['newPayment'];
	$_SESSION['oldPayment'] = $_POST['oldPayment'];
	$_SESSION['tradeYear'] = $_POST['tradeYear'];
	$_SESSION['tradeModel'] = $_POST['tradeModel'];
	
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
 
 
$sqlorderby_Recordset1 = "custID";
if (isset($sql_orderby)) {
  $sqlorderby_Recordset1 = $sql_orderby;
}
// Defining List Recordset variable
$tfmsqlstr_Recordset1 = " WHERE 1=1 ";
if (isset($tfmsqlstr)) {
  $tfmsqlstr_Recordset1 = $tfmsqlstr;
}
// Defining List Recordset variable
$sqlorderby_Recordset1 = "custID";
if (isset($sql_orderby)) {
  $sqlorderby_Recordset1 = $sql_orderby;
}
mysql_select_db($database_mydatabase, $mydatabase);
 
$query_Recordset1 = "SELECT *, newPayment-oldPayment AS difference FROM contacts {$tfmsqlstr_Recordset1}  ORDER BY $sql_orderby";
$Recordset1 = mysql_query($query_Recordset1, $mydatabase) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
 
 
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>
<?php
 
$tfm_saveParams = explode(",","");
$tfm_keepParams = "";
if($tfm_order == "ASC") {
	$tfm_order = "DESC";
}else{
	$tfm_order = "ASC";
};
while (list($key,$val) = each($tfm_saveParams)) {
	if(isset($_GET[$val]))$tfm_keepParams .= ($val)."=".urlencode($HTTP_GET_VARS[$val])."&";	
	if(isset($_POST[$val]))$tfm_keepParams .= ($val)."=".urlencode($HTTP_POST_VARS[$val])."&";
}
$tfm_orderbyURL = $HTTP_SERVER_VARS["PHP_SELF"]."?".$tfm_keepParams."tfm_order=".$tfm_order."&tfm_orderby=";
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>All Records</title>
<link href="anthony.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<div id="form_list_all">
  <div id="searchBox">
    <form action="" method="post" name="form1" class="formText" id="form1">
      <label>
      <input name="searchID" type="text" class="formText" id="searchID" size="32" />
      </label>
      <label>
      <input name="button" type="submit" class="formText" id="button" value="Search Records" />
      </label>
      <label></label>
      <input name="button2" type="submit" class="formText" id="button2" value="Clear Search Results" />
    </form>
    <br />
  </div>
  <table border="1" align="center" class="formText">
    <tr>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>custID">Client ID</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>quoteDate">Date</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>salutation">Salutation</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>firstName">First Name</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>lastName">Last Name</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>phoneAlt">Cell Phone</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>phone">Home Phone</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>tradeYear">Trade-In Year</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>tradeMake">Trade-In Make</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>tradeModel">Trade-In Model</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>quotedYear">New Car Year</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>quotedMake">New Car Make</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>quotedModel">New Car Model</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>followUpLetter">Follow Up <br />
        Letter Sent</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>followUpCall">Follow Up <br />
        Call Made</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>apptScheduled">Appointment <br />
        Scheduled</a></td>
      <td><a href="<?Php echo ($tfm_orderbyURL); ?>difference">Payment <br />
        Difference</a></td>
    </tr>
    <?php do { ?>
    <tr>
      <td><a href="record_detail.php?recordID=<?php echo $row_Recordset1['custID']; ?>"> <?php echo $row_Recordset1['custID']; ?>&nbsp; </a> </td>
      <td><?php echo $row_Recordset1['quoteDate']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['salutation']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['lastName']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['firstName']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['phone']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['phoneAlt']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['tradeYear']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['tradeMake']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['tradeModel']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['quotedYear']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['quotedMake']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['quotedModel']; ?>&nbsp;</td>
      <td><?php echo $row_Recordset1['followUpLetter']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['followUpCall']; ?>&nbsp; </td>
      <td><?php echo $row_Recordset1['apptScheduled']; ?>&nbsp; </td>
      <td><?php echo ($row_Recordset1['difference'] < 0) ? '<span style="color:red;">' . $row_Recordset1['difference'] . '</span>' : $row_Recordset1['difference']; ?>&nbsp; </td>
    </tr>
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
  </table>
  
  <table border="0" class="formText">
    <tr>
      <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
          <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>">First</a>
          <?php } // Show if not first page ?>
      </td>
      <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
          <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>">Previous</a>
          <?php } // Show if not first page ?>
      </td>
      <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
          <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Next</a>
          <?php } // Show if not last page ?>
      </td>
      <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
          <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>">Last</a>
          <?php } // Show if not last page ?>
      </td>
    </tr>
  </table>
  <span class="formText">Records <?php echo ($startRow_Recordset1 + 1) ?> to <?php echo min($startRow_Recordset1 + $maxRows_Recordset1, $totalRows_Recordset1) ?> of <?php echo $totalRows_Recordset1 ?></span><br />
</div>
<br />
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:

<?php
if (isset($_POST['lastName']) && !empty($_POST['lastName'])) {
  session_start();
    $_SESSION['salutation'] = $_POST['salutation'];
	$_SESSION['lastName'] = $_POST['lastName'];
	$_SESSION['firstName'] = $_POST['firstName'];
	$_SESSION['quotedYear'] = $_POST['quotedYear'];
	$_SESSION['quotedModel'] = $_POST['quotedModel'];
	$_SESSION['newPayment'] = $_POST['newPayment'];
	$_SESSION['oldPayment'] = $_POST['oldPayment'];
	$_SESSION['tradeYear'] = $_POST['tradeYear'];
	$_SESSION['tradeModel'] = $_POST['tradeModel'];
	
}
?>
<?php require_once('../../Connections/mydatabase.php'); ?><?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE contacts SET quoteDate=%s, salutation=%s, lastName=%s, firstName=%s, phone=%s, phoneAlt=%s, address=%s, city=%s, `state`=%s, zip=%s, email=%s, stockNumberOld=%s, `tradeYear`=%s, tradeMake=%s, tradeModel=%s, lienholder=%s, acctNum=%s, payoffAmt=%s, tradeACV=%s, oldPayment=%s, stockNumberNew=%s, quotedYear=%s, quotedMake=%s, quotedModel=%s, newPayment=%s, followUpLetter=%s, followUpLetterNotes=%s, followUpCall=%s, followUpCallNotes=%s, apptScheduled=%s, apptScheduledNotes=%s, notes=%s WHERE custID=%s",
                       GetSQLValueString($_POST['quoteDate'], "text"),
                       GetSQLValueString($_POST['salutation'], "text"),
                       GetSQLValueString($_POST['lastName'], "text"),
                       GetSQLValueString($_POST['firstName'], "text"),
                       GetSQLValueString($_POST['phone'], "text"),
                       GetSQLValueString($_POST['phoneAlt'], "text"),
                       GetSQLValueString($_POST['address'], "text"),
                       GetSQLValueString($_POST['city'], "text"),
                       GetSQLValueString($_POST['state'], "text"),
                       GetSQLValueString($_POST['zip'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['stockNumberOld'], "text"),
                       GetSQLValueString($_POST['tradeYear'], "text"),
                       GetSQLValueString($_POST['tradeMake'], "text"),
                       GetSQLValueString($_POST['tradeModel'], "text"),
                       GetSQLValueString($_POST['lienholder'], "text"),
                       GetSQLValueString($_POST['acctNum'], "text"),
                       GetSQLValueString($_POST['payoffAmt'], "text"),
                       GetSQLValueString($_POST['tradeACV'], "text"),
                       GetSQLValueString($_POST['oldPayment'], "text"),
                       GetSQLValueString($_POST['stockNumberNew'], "text"),
                       GetSQLValueString($_POST['quotedYear'], "text"),
                       GetSQLValueString($_POST['quotedMake'], "text"),
                       GetSQLValueString($_POST['quotedModel'], "text"),
                       GetSQLValueString($_POST['newPayment'], "text"),
                       GetSQLValueString($_POST['followUpLetter'], "text"),
                       GetSQLValueString($_POST['followUpLetterNotes'], "text"),
                       GetSQLValueString($_POST['followUpCall'], "text"),
                       GetSQLValueString($_POST['followUpCallNotes'], "text"),
                       GetSQLValueString($_POST['apptScheduled'], "text"),
                       GetSQLValueString($_POST['apptScheduledNotes'], "text"),
                       GetSQLValueString($_POST['notes'], "text"),
                       GetSQLValueString($_POST['custID'], "int"));
 
  mysql_select_db($database_mydatabase, $mydatabase);
  $Result1 = mysql_query($updateSQL, $mydatabase) or die(mysql_error());
 
  $updateGoTo = "complete.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}
 
$maxRows_DetailRS1 = 100;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
  $pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;
 
$colname_DetailRS1 = "-1";
if (isset($_GET['recordID'])) {
  $colname_DetailRS1 = $_GET['recordID'];
}
mysql_select_db($database_mydatabase, $mydatabase);
$query_DetailRS1 = sprintf("SELECT * FROM contacts WHERE custID = %s", GetSQLValueString($colname_DetailRS1, "int"));
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $mydatabase) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
 
if (isset($_GET['totalRows_DetailRS1'])) {
  $totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
  $all_DetailRS1 = mysql_query($query_DetailRS1);
  $totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;
 
mysql_select_db($database_mydatabase, $mydatabase);
$query_Recordset4 = "SELECT * FROM makes";
$Recordset4 = mysql_query($query_Recordset4, $mydatabase) or die(mysql_error());
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
$totalRows_Recordset4 = mysql_num_rows($Recordset4);
 
mysql_select_db($database_mydatabase, $mydatabase);
$query_RecordsetStates = "SELECT * FROM `states`";
$RecordsetStates = mysql_query($query_RecordsetStates, $mydatabase) or die(mysql_error());
$row_RecordsetStates = mysql_fetch_assoc($RecordsetStates);
$totalRows_RecordsetStates = mysql_num_rows($RecordsetStates);
 
mysql_select_db($database_mydatabase, $mydatabase);
$query_RecordsetYear = "SELECT * FROM year";
$RecordsetYear = mysql_query($query_RecordsetYear, $mydatabase) or die(mysql_error());
$row_RecordsetYear = mysql_fetch_assoc($RecordsetYear);
$totalRows_RecordsetYear = mysql_num_rows($RecordsetYear);
 
mysql_select_db($database_mydatabase, $mydatabase);
$query_RecordsetNewCarYear = "SELECT * FROM year";
$RecordsetNewCarYear = mysql_query($query_RecordsetNewCarYear, $mydatabase) or die(mysql_error());
$row_RecordsetNewCarYear = mysql_fetch_assoc($RecordsetNewCarYear);
$totalRows_RecordsetNewCarYear = mysql_num_rows($RecordsetNewCarYear);
 
mysql_select_db($database_mydatabase, $mydatabase);
$query_RecordsetTradeInYear = "SELECT * FROM year";
$RecordsetTradeInYear = mysql_query($query_RecordsetTradeInYear, $mydatabase) or die(mysql_error());
$row_RecordsetTradeInYear = mysql_fetch_assoc($RecordsetTradeInYear);
$totalRows_RecordsetTradeInYear = mysql_num_rows($RecordsetTradeInYear);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Client Information Update</title>
<link href="anthony.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
  <div id="form">
    <table align="center" class="formText">
      <tr valign="baseline">
        <td width="177" class="headerText">Client Information</td>
      <td width="166">&nbsp;</td>
        <td width="163" class="formTextRed">Client ID: <?php echo $row_DetailRS1['custID']; ?></td>
      </tr>
      <tr valign="baseline">
        <td>Date (mm/dd/yyyy)</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="quoteDate" value="<?php echo htmlentities($row_DetailRS1['quoteDate'], ENT_COMPAT, 'UTF-8'); ?>" size="10" /></td>
      <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td>Salutation (Mr., Mrs., Ms.)</td>
        <td>First Name</td>
        <td>Last Name</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="salutation" value="<?php echo htmlentities($row_DetailRS1['salutation'], ENT_COMPAT, 'UTF-8'); ?>" size="10" /></td>
      <td><input type="text" name="firstName" value="<?php echo htmlentities($row_DetailRS1['firstName'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
        <td><input type="text" name="lastName" value="<?php echo htmlentities($row_DetailRS1['lastName'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      </tr>
      <tr valign="baseline">
        <td>Address</td>
      <td>City</td>
        <td>State Zip</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="address" value="<?php echo htmlentities($row_DetailRS1['address'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
        <td><input type="text" name="city" value="<?php echo htmlentities($row_DetailRS1['city'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
        <td><select name="state">
          <?php
do {  
?>
          <option value="<?php echo $row_RecordsetStates['abb']?>"<?php if (!(strcmp($row_RecordsetStates['abb'], htmlentities($row_DetailRS1['state'], ENT_COMPAT, 'UTF-8')))) {echo "selected=\"selected\"";} ?>><?php echo $row_RecordsetStates['abb']?></option>
          <?php
} while ($row_RecordsetStates = mysql_fetch_assoc($RecordsetStates));
  $rows = mysql_num_rows($RecordsetStates);
  if($rows > 0) {
      mysql_data_seek($RecordsetStates, 0);
	  $row_RecordsetStates = mysql_fetch_assoc($RecordsetStates);
  }
?>
        </select> <input type="text" name="zip" value="<?php echo htmlentities($row_DetailRS1['zip'], ENT_COMPAT, 'UTF-8'); ?>" size="5" /></td>
      </tr>
      <tr valign="baseline">
        <td>Cell Phone</td>
        <td>Home Phone</td>
        <td>Email</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="phoneAlt" value="<?php echo htmlentities($row_DetailRS1['phoneAlt'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      <td><input type="text" name="phone" value="<?php echo htmlentities($row_DetailRS1['phone'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
        <td><input type="text" name="email" value="<?php echo htmlentities($row_DetailRS1['email'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      </tr>
      <tr valign="baseline">
        <td colspan="2" class="headerText">Trade-In Information</td>
      <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td>Trade-In Stock Number</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="stockNumberOld" value="<?php echo htmlentities($row_DetailRS1['stockNumberOld'], ENT_COMPAT, 'UTF-8'); ?>" size="17" /></td>
      <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td>Trade-In Year</td>
      <td>Trade-In Make</td>
        <td>Trade-In Model</td>
      </tr>
      <tr valign="baseline">
        <td><select name="tradeYear">
          <?php
do {  
?>
          <option value="<?php echo $row_RecordsetTradeInYear['Year']?>"<?php if (!(strcmp($row_RecordsetTradeInYear['Year'], htmlentities($row_DetailRS1['tradeYear'], ENT_COMPAT, 'UTF-8')))) {echo "selected=\"selected\"";} ?>><?php echo $row_RecordsetTradeInYear['Year']?></option>
          <?php
} while ($row_RecordsetTradeInYear = mysql_fetch_assoc($RecordsetTradeInYear));
  $rows = mysql_num_rows($RecordsetTradeInYear);
  if($rows > 0) {
      mysql_data_seek($RecordsetTradeInYear, 0);
	  $row_RecordsetTradeInYear = mysql_fetch_assoc($RecordsetTradeInYear);
  }
?>
        </select></td>
      <td><select name="tradeMake">
        <?php
do {  
?>
        <option value="<?php echo $row_Recordset4['makes']?>"<?php if (!(strcmp($row_Recordset4['makes'], $row_DetailRS1['tradeMake']))) {echo "selected=\"selected\"";} ?>><?php echo $row_Recordset4['makes']?></option>
        <?php
} while ($row_Recordset4 = mysql_fetch_assoc($Recordset4));
  $rows = mysql_num_rows($Recordset4);
  if($rows > 0) {
      mysql_data_seek($Recordset4, 0);
	  $row_Recordset4 = mysql_fetch_assoc($Recordset4);
  }
?>
      </select></td>
        <td><input type="text" name="tradeModel" value="<?php echo htmlentities($row_DetailRS1['tradeModel'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      </tr>
      <tr valign="baseline">
        <td>Lienholder</td>
      <td>Account Number</td>
        <td>Payoff Amount</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="lienholder" value="<?php echo htmlentities($row_DetailRS1['lienholder'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      <td><input type="text" name="acctNum" value="<?php echo htmlentities($row_DetailRS1['acctNum'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
        <td><input type="text" name="payoffAmt" value="<?php echo htmlentities($row_DetailRS1['payoffAmt'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      </tr>
      <tr valign="baseline">
        <td>Trade-In ACV</td>
      <td>Current Payment</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="tradeACV" value="<?php echo htmlentities($row_DetailRS1['tradeACV'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      <td><input type="text" name="oldPayment" value="<?php echo htmlentities($row_DetailRS1['oldPayment'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2" class="headerText">New Car Information </td>
      <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td>New Car Stock Number</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="stockNumberNew" value="<?php echo htmlentities($row_DetailRS1['stockNumberNew'], ENT_COMPAT, 'UTF-8'); ?>" size="17" /></td>
      <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td>New Car Year</td>
      <td>New Car Make</td>
        <td>New Car Model</td>
      </tr>
      <tr valign="baseline">
        <td><select name="quotedYear">
          <?php
do {  
?>
          <option value="<?php echo $row_RecordsetNewCarYear['Year']?>"<?php if (!(strcmp($row_RecordsetNewCarYear['Year'], htmlentities($row_DetailRS1['quotedYear'], ENT_COMPAT, 'UTF-8')))) {echo "selected=\"selected\"";} ?>><?php echo $row_RecordsetNewCarYear['Year']?></option>
          <?php
} while ($row_RecordsetNewCarYear = mysql_fetch_assoc($RecordsetNewCarYear));
  $rows = mysql_num_rows($RecordsetNewCarYear);
  if($rows > 0) {
      mysql_data_seek($RecordsetNewCarYear, 0);
	  $row_RecordsetNewCarYear = mysql_fetch_assoc($RecordsetNewCarYear);
  }
?>
        </select></td>
      <td><select name="quotedMake">
        <?php
do {  
?>
        <option value="<?php echo $row_Recordset4['makes']?>"<?php if (!(strcmp($row_Recordset4['makes'], htmlentities($row_DetailRS1['quotedMake'], ENT_COMPAT, 'UTF-8')))) {echo "selected=\"selected\"";} ?>><?php echo $row_Recordset4['makes']?></option>
        <?php
} while ($row_Recordset4 = mysql_fetch_assoc($Recordset4));
  $rows = mysql_num_rows($Recordset4);
  if($rows > 0) {
      mysql_data_seek($Recordset4, 0);
	  $row_Recordset4 = mysql_fetch_assoc($Recordset4);
  }
?>
      </select></td>
        <td><input type="text" name="quotedModel" value="<?php echo htmlentities($row_DetailRS1['quotedModel'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      </tr>
      <tr valign="baseline">
        <td>New Car Payment</td>
      <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td><input type="text" name="newPayment" value="<?php echo htmlentities($row_DetailRS1['newPayment'], ENT_COMPAT, 'UTF-8'); ?>" size="20" /></td>
      <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
            <td class="headerText">Follow Up </td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2">Follow Up Letter Sent:
          <label>
          <input type="radio" name="followUpLetter" value="Yes <?php if (!(strcmp(htmlentities($row_DetailRS1["followUpLetter"], ENT_COMPAT, 'UTF-8'),"Yes"))) {echo "CHECKED";} ?>" />
  Yes</label>
          <label>
          <input type="radio" name="followUpLetter" value="No" <?php if (!(strcmp(htmlentities($row_DetailRS1["followUpLetter"], ENT_COMPAT, 'UTF-8'),"No"))) {echo "CHECKED";} ?> />
  No</label></td>
      <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2"><textarea name="followUpLetterNotes" cols="40" rows="3"><?php echo htmlentities($row_DetailRS1["followUpLetterNotes"], ENT_COMPAT, 'UTF-8'); ?></textarea></td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2">Follow Up Call Made:
          <input type="radio" name="followUpCall" value="Yes <?php if (!(strcmp(htmlentities($row_DetailRS1["followUpCall"], ENT_COMPAT, 'UTF-8'),"Yes"))) {echo "CHECKED";} ?>" />
  Yes
  <input type="radio" name="followUpCall" value="No" <?php if (!(strcmp(htmlentities($row_DetailRS1["followUpLetter"], ENT_COMPAT, 'UTF-8'),"No"))) {echo "CHECKED";} ?>  />
  No</td>
      <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2"><textarea name="followUpCallNotes" cols="40" rows="3"><?php echo htmlentities($row_DetailRS1["followUpCallNotes"], ENT_COMPAT, 'UTF-8'); ?></textarea></td>
      <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2">Scheduled Appointment:
          <label>
          <input type="radio" name="apptScheduled" value="Yes" <?php if (!(strcmp(htmlentities($row_DetailRS1["apptScheduled"], ENT_COMPAT, 'UTF-8'),"Yes"))) {echo "CHECKED";} ?> />
  Yes</label>
          <label>
          <input type="radio" name="apptScheduled" value="No" <?php if (!(strcmp(htmlentities($row_DetailRS1["apptScheduled"], ENT_COMPAT, 'UTF-8'),"No"))) {echo "CHECKED";} ?> />
  No</label></td>
      <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2" valign="baseline"><textarea name="apptScheduledNotes" cols="40" rows="3"><?php echo htmlentities($row_DetailRS1["apptScheduledNotes"], ENT_COMPAT, 'UTF-8'); ?></textarea></td>
        <td valign="baseline">&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2">Additional Notes      </td>
      <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td colspan="2" valign="baseline"><textarea name="notes" cols="40" rows="3"><?php echo htmlentities($row_DetailRS1["notes"], ENT_COMPAT, 'UTF-8'); ?></textarea></td>
        <td valign="baseline">&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td>&nbsp;      </td>
      <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr valign="baseline">
        <td><input type="submit" value="Update record" /></td>
      <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
    </table>
  </div>
  <input type="hidden" name="MM_update" value="form1" />
  <input type="hidden" name="custID" value="<?php echo $row_DetailRS1['custID']; ?>" />
</form>
<p>&nbsp;</p>
</body>
</html><?php
mysql_free_result($DetailRS1);
 
mysql_free_result($Recordset4);
 
mysql_free_result($RecordsetStates);
 
mysql_free_result($RecordsetYear);
 
mysql_free_result($RecordsetNewCarYear);
 
mysql_free_result($RecordsetTradeInYear);
?>
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434: