query("insert into $tbl_user set fname='$fname',lname='$lname',company_name='$company_name',email='$email',address='$address',city='$city',zip='$zip',country_id='$country_id',state='$state',phone='$phone',fax='$fax',mobile='$mobile',register_date=now(),ip='".$_SERVER['REMOTE_ADDR']."',status=1 "); $_SESSION['sess_msg']='Customer added successfully'; }else{ $sql=" update $tbl_user set fname='$fname',lname='$lname',company_name='$company_name',email='$email',address='$address',city='$city',zip='$zip',country_id='$country_id',state='$state',phone='$phone',fax='$fax',mobile='$mobile' "; $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $_SESSION['sess_msg']='Customer updated successfully'; } header("location:user-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from $tbl_user where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?>

Admin: AddUpdate Customers First Name: Last Name: Email: Company Name: Address: <?php echo stripslashes($result->address);?> City: State: Zip: Country: -Select Country- query("select * from $tbl_country where status=1 "); while($resultCountry=$obj->fetchNextObject($countryArr)){?> id==$result->country_id){ ?>selected>country); ?> Mobile: Phone: Fax: