i need to display the fullname and email of the logged in user.
<?php
session_start();
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("db_register") or die(mysql_error());
$query = "SELECT` fullname`, `email` FROM `members` WHERE `username`='".$_SESSION['user']."' LIMIT 1";
if($doQuery = mysql_query($query)) {
if(mysql_num_rows($doQuery)) {
$user = mysql_fetch_assoc($doQuery);
print_r($user);
} else {
echo 'No result returned for the query: '.$query;
}
} else {
echo 'The following query failed: '.$query;
}
$id = $user['id'];
$fullname = $user['fullname'];
$email = $user['email'];
}
?>
<br>
Fullname : <?php echo $fullname; ?>
<br>
Email : <? echo $email; ?>
?>
HELP please .