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.
Bookmarks