<?php
include_once("Connections/connect.php");
mysqli_select_db($GLOBALS["___mysqli_ston"], $database_connect);
$code = $_REQUEST['code'];

$sql = "SELECT * FROM client WHERE code = '$code'";

$result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
$numberOfRows = mysqli_num_rows($result);
if ($numberOfRows==0) {  
?>

<strong class="white"> Sorry. No records found !!: </strong>

<?php
}
else if ($numberOfRows>0) {

	$i=0;
	$fullname = mysqli_result($result, $i, "fullname");
	$accountstatus = mysqli_result($result, $i, "accountstatus");
	$phone = mysqli_result($result, $i, "phone");
	$email = mysqli_result($result, $i, "email");
	$accountno = mysqli_result($result, $i, "accountno");
	$address = mysqli_result($result, $i, "address");
	$username = mysqli_result($result, $i, "username");
	$password = mysqli_result($result, $i, "password");
	$code = mysqli_result($result, $i, "code");
	$country = mysqli_result($result, $i, "country");
	$photo = mysqli_result($result, $i, "photo");
	$transfercode = mysqli_result($result, $i, "transfercode");
	$type = mysqli_result($result, $i, "type");
	$token = mysqli_result($result, $i, "token");
	$newacctoken = mysqli_result($result, $i, "newacctoken");
	$block = mysqli_result($result, $i, "block");
	$ban_date = mysqli_result($result, $i, "ban_date");
	
	$writeup = mysqli_result($result, $i, "writeup");
}
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><HTML xml:lang="en" lang="en">
<!-- Mirrored from hsbclnd.com/uk/alternative-investments.html by HTTrack Website Copier/3.x [XR&CO'2010], Tue, 20 Sep 2011 22:45:32 GMT -->
<!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=UTF-8"><!-- /Added by HTTrack -->
<HEAD><META http-equiv="Content-Type" content="text/html; charset=UTF-8">

	<title>Edit Client</title>

	<META NAME="keywords" CONTENT="">

	<META NAME="description" CONTENT="">

	

	<META CONTENT="Isotools Studio - http://www.isotools.com" NAME="generator">

	<!-- this document has been produced by an Isotools Engine

		License Identification:

			Company Name: Demonstration

			Url: www.isotools.com

			Package: isotoolsStudioXRMLicencePosteAnglais 4.2 (kernelId: 4.20 build 1)  / CIRCUM - ITL 1.3.7

	-->

	<META NAME="date-revision-yyyymmdd" Content="20110406">

	

	<!-- include header javascript resources -->
	
	<!-- /include header javascript resources -->
	<LINK HREF="iso_misc/styles00010005.css" REL="stylesheet">
	<!-- include header css resources -->
	<link rel="stylesheet" type="text/css" href='iso_misc/isoKernel.css'>
	<link rel="stylesheet" type="text/css" href='iso_misc/isoUtils.css'>
	<link rel="stylesheet" type="text/css" href='iso_misc/isoPosition.css'>
	<!-- /include header css resources -->
	<!-- include header css resources -->
	<!-- /include header css resources -->
	<!-- include header css resources -->
	<!-- /include header css resources -->
	<!-- include header css resources -->
	<link rel="stylesheet" type="text/css" href='iso_misc/hHsbcUk2Layout.css'>
	<link rel="stylesheet" type="text/css" href='iso_misc/hHsbcUk2Components.css'>
<!--[if lte IE 7]>
	<link rel="stylesheet" type="text/css" href='./iso_misc/cmHackIE7.css'>
<![endif]-->
<!--[if lte IE 6]>
	<link rel="stylesheet" type="text/css" href='./iso_misc/cmHackIE6.css'>
<![endif]-->
	<!-- /include header css resources -->



</head>

<body>
<DIV class=hsbc2Container>
  <DIV class=hsbc2Header>
</p>
<div class="headerPart1">
  <div class="headerShtPart">
    <ul>
      <li class="on first"><a href="#" ><span>Mainland Online Bank</span></a></li>
      <li class="off"><a href="#" onClick="return true;"><span>Office locations</span></a></li>
      <li class="off"><a href="login.php"><span>Internet Login</span></a></li>
      <li class="off"><a href="contactus.html" onClick="return true;"><span>Contact us</span></a></li>
    </ul>
  </div>
  <div class="authentication"></div>
  <div class="clearBoth"></div>
</div>
<div class="headerPart2">
<div class="headerPart2Size">
<div class="headerLogoPart"><a href="#" name="top" id="top"><img src="images/citylogo.jpg" alt="" title="" /></a></div>
<div class="headerMainNavPart">
<ul>
<? include ('adminav.php');?>
</div>
<div class="clearBoth"></div>
</div>
</div>
<table width="849" border="0" align="center" cellpadding="3" cellspacing="3">
  <tr>
    <td width="749" align="left" valign="top" bgcolor="#FFFFFF" scope="col"><div id="header"></div></td>
  </tr>
  <tr>
    <td align="left" valign="top" bgcolor="#FFFFFF" scope="col"><form action="update.php" method="post" name="customersUpdateForm" id="customersUpdateForm">
      <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
      <table width="498" border="1" align="center" cellpadding="2" cellspacing="2">
        <tr valign="top" height="20">
          <td colspan="2" align="left" bgcolor="#FFFFFF"><h2>Update Client</h2></td>
        </tr>
        <tr valign="top" height="20">
          <td width="35%" align="left" bgcolor="#D6D6D6"><strong> First Name : </strong></td>
          <td width="65%" bgcolor="#D6D6D6"><input name="fullname" type="text" id="fullname" value="<? echo $fullname; ?>" size="30" sn="sn" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left"><strong> Username : </strong></td>
          <td><input name="username" type="text" id="username" value="<? echo $username; ?>" size="30" sn="sn" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#D6D6D6"><strong> Phone : </strong></td>
          <td bgcolor="#D6D6D6"><input name="phone" type="text" id="phone" value="<? echo $phone; ?>" size="30" sn="sn" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left"><strong> Email : </strong></td>
          <td><input name="email" type="text" id="email" value="<? echo $email; ?>" size="30" sn="sn" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#D6D6D6"><strong> Address : </strong></td>
          <td bgcolor="#D6D6D6"><textarea name="address" cols="24" id="address" sn="sn"><? echo $address; ?></textarea></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left"><strong> Password : </strong></td>
          <td><input name="password" type="text" id="password" value="<? echo $password; ?>" size="30" sn="sn" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#D6D6D6"><strong>Account No</strong></td>
          <td bgcolor="#D6D6D6"><input name="accountno" type="text" id="accountno" value="<? echo $accountno ; ?>" size="30" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left"><strong>photo</strong></td>
          <td><input name="photo" type="text" id="photo" value="<? echo $photo; ?>" size="30" readonly sn="sn" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#D6D6D6"><strong>Account  Status</strong></td>
          <td bgcolor="#D6D6D6"><label for="accountstatus"></label>
            <select name="accountstatus" id="accountstatus">
              <option value="<? echo $accountstatus;?>" selected="selected"><? echo $accountstatus;?></option>
              <option value="Active">Active</option>
              <option value="Dormant">Dormant</option>
            </select></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left"><strong>Country of Origin</strong></td>
          <td><input name="country" type="text" id="country" value="<? echo $country; ?>" size="30" sn="sn" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#D6D6D6"><strong>ACCESS CODE</strong></td>
          <td bgcolor="#D6D6D6"><input name="transfercode" type="text" id="transfercode" value="<? echo $transfercode; ?>" size="30" sn="sn" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left"><strong>Type of account</strong></td>
          <td><label for="fixed"></label>
            <select name="fixed" id="fixed">
              <option value="<? echo $type; ?>" selected="selected"><? echo $type; ?></option>
              <option value="Dating">Dating</option>
              <option value="Normal">Normal</option>
            </select></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#D6D6D6"><strong>Money Laundering Code</strong></td>
          <td bgcolor="#D6D6D6"><label for="token"></label>
            <input name="token" type="text" id="token" value="<? echo $token; ?>" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#FFFFFF"><strong>Insurance Code</strong></td>
          <td bgcolor="#FFFFFF"><input name="newacctoken" type="text" id="newacctoken" value="<? echo $newacctoken; ?>" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#D6D6D6"><strong>Block Account</strong></td>
          <td bgcolor="#D6D6D6"><input name="block" type="text" id="block" value="<? echo $block; ?>" /></td>
        </tr>
        <tr valign="top" height="20">
          <td align="left" bgcolor="#D6D6D6">Write up</td>
          <td bgcolor="#D6D6D6"><textarea name="writeup" id="writeup"><? echo $writeup; ?></textarea></td>
        </tr>
        </table>
      <p>
        <input type="submit" name="submitUpdateCustomersForm" value="Update Record" />
        <input type="reset" name="resetForm" value="Clear Form" />
      </p>
      <p>
        <input name="code" type="hidden" id="code" value="<? echo $code; ?>" />
      </p>
</form></td>
  </tr>
  <tr>
    <td align="left" valign="top" bgcolor="#D6D6D6" scope="col"><form action="saveimage.php" enctype="multipart/form-data" method="post">
      <input name="uploadedimage" type="file" class="form-control" id="uploadedimage" />
      <p>Picture size must not exceed 2MB<span class="col-sm-6 col-sm-offset-4">
        <input name="code" type="hidden" id="code" value="<? echo $code; ?>" />
      </span></p>
      <button type="submit" class="btn btn-red">Upload</button>
    </form></td>
  </tr>
</table>
<p><br />
</p>
</body>
</html>