"; ?>
include_once("include/db_connection.php");
$thisCustomer_id = $_REQUEST['customer_idField'];
$sql = "SELECT * FROM customers WHERE customer_id = '$thisCustomer_id'";
$result = MYSQL_QUERY($sql);
$numberOfRows = MYSQL_NUMROWS($result);
if ($numberOfRows==0) {
?>
Sorry. No records found !!
}
else if ($numberOfRows>0) {
$i=0;
$thisCustomer_id = MYSQL_RESULT($result,$i,"customer_id");
$thisFname = MYSQL_RESULT($result,$i,"fname");
$thisMname = MYSQL_RESULT($result,$i,"mname");
$thisLname = MYSQL_RESULT($result,$i,"lname");
$thisCompany = MYSQL_RESULT($result,$i,"company");
$thisTitle = MYSQL_RESULT($result,$i,"title");
$thisAddress1 = MYSQL_RESULT($result,$i,"address1");
$thisAddress2 = MYSQL_RESULT($result,$i,"address2");
$thisAddress3 = MYSQL_RESULT($result,$i,"address3");
$thisCity = MYSQL_RESULT($result,$i,"city");
$thisState_province = MYSQL_RESULT($result,$i,"state_province");
$thisCountry = MYSQL_RESULT($result,$i,"country");
$thisPostal_code = MYSQL_RESULT($result,$i,"postal_code");
$thisPhone = MYSQL_RESULT($result,$i,"phone");
$thisFax = MYSQL_RESULT($result,$i,"fax");
}
?>
No comments:
Post a Comment