Alright I want it to show the persons e-mail when they are loged in on this profile page so that they can change their account e-mail... this is the forum code
<?php if(isset($_POST['Login'])) { if($_POST['username']!='' && $_POST['password']!='') { //Use the input username and password and check against 'users' table $query = mysql_query('SELECT ID, Username, Active FROM users WHERE Username = "'.mysql_real_escape_string($_POST['username']).'" AND Password = "'.mysql_real_escape_string(md5($_POST['password'])).'"');
if(mysql_num_rows($query) == 1) { $row = mysql_fetch_assoc($query); if($row['Active'] == 1) { session_start(); $_SESSION['user_id'] = $row['ID']; $_SESSION['user'] = $row['Username']; $_SESSION['email'] = $row['Email']; $_SESSION['logged_in'] = TRUE; } else { $error = 'Your membership was not activated. Please open the email that we sent and click on the activation link'; } } else { $error = 'Login failed !'; } } else { $error = 'Please user both your username and password to access your account'; } } ?>
I figured it out on my own, thanks for trying to help I just hadn't given you all the code before so you could not see that I had not called Email when query database.