Sunday, December 19, 2010

Update data php

"; ?>
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