<?php
require('db.php');
$username = $_POST['username'];
$password = $_POST['password'];

$query  = "SELECT * FROM user WHERE username = '".$username."'";
$result = mysql_query($query) or die(mysql_error());

$prend = mysql_fetch_array($result);
echo $prend['username'];
?>