I'm making a user based website useing php mysql. I have users data in mysql tables. When i try to get/display data on page using this script, it works pretty good.

<?php

$connect = mysql_connect("localhost","root","");

mysql_select_db("mydatabase");

$email = isset($_SESSION['email']);

$query = mysql_query("SELECT * FROM
users WHERE email = '[email protected]'");

WHILE($rows = mysql_fetch_array($query)):

$firstname = $rows['firstname'];

$lastname = $rows['lastname'];

echo "$firstname $lastname";

endwhile;

?>

But when I try to get/display user's data as current logged in user by this script, it doesn't work.


<?php

$connect = mysql_connect("localhost","root","");

mysql_select_db("mydatabase");

$email = isset($_SESSION['email']);

$query = mysql_query("SELECT * FROM
users WHERE email = '$email'");

WHILE($rows = mysql_fetch_array($query)):

$firstname = $rows['firstname'];

$lastname = $rows['lastname'];

echo "$firstname $lastname";

endwhile;

?>

I don't know what is the problem. Please guide me.