im getting an error on my select statement. Once I login using email and password, Im trying display the email.
<?
session_start();
if(!session_is_registered(Email)){
header("location:direct.php");
}
?>
<?php include("header.php"); ?>
<?php include("config.php"); ?>
<table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr><td>
<?php
SELECT * FROM $data1 WHERE Email='$Email';
$result=MYSQL_QUERY($query) or die(mysql_error());
$data=mysql_fetch_array($result);
echo $Email
?>
</td>
<td width="200">Update</td>
</tr></table>
<?php include("footer.php"); ?>