Untitled

<?php ob_start();
session_start();
$con=mysql_connect('localhost','root') or die('error');
$query=mysql_select_db('login',$con);


$sql1=mysql_query("SELECT * FROM login_tbl WHERE lastname='aw'");
while($rows=mysql_fetch_array($sql1)){

$aw=$rows['lastname'];
echo $aw;

}

?>
<html>
<head>
<title>
</title>
</head>
<style>
body{
background-color:#CCC;
margin:0px;
color:#FFF;
}
#page{
background-color:#666;
border:5px ;
width:75%;
margin-left:auto;
margin-right:auto;
padding:15px;
opacity:0.4;
filter:alpha(opacity=40);
border-radius: 10px;
color:#FFF;
}
#regi{
background-color:#666;
border-radius: 10px;
width:50%;
height:90%;
opacity:0.4;
filter:alpha(opacity=40);


}

</style>
<body>
<div id="page">
<h1 align="center">PROFILE</h1>
</div>

<form  method="POST">

<br>
<br>
<br>
<br><center>
<div id ="regi">

<center><br><br><br>
Surname:<input type="text" name="lastname" id="lastname" ">
<br>Firstname:<input type="text" name="firstname">
<br>Middlename:<input type="text" name="middlename">
<br/>
Username:<input type="text" name="username" id="username" value="<?php echo $_SESSION['username'];?>">
<br/>
Password:<input type="password" name="password" id="password" value="<?php echo $_SESSION['password'];?>">
<a href="changepass.php"><input type="submit" name="submit" value="ChangePassword"></a>
<br><br><br><br>
<h4>RESULTS</h4>


<input type="button" value="BACK">
</form>

</body>
</html>