Please Help! Site Going live in 2 days....
Posted: Fri Dec 13, 2002 5:52 pm
I need help fast! The site is going live in two days and i have a big problem. I have built a log-in script that works but i want to allow the user to change their password and email address. Below is the code but it doen't work.
Thanks for your help!
-Michael Ewald
Code: Select all
<?php
include 'db.php';
session_start();
$first_name = $_SESSIONї'first_name'];
$last_name = $_SESSIONї'last_name'];
// Current Settings
$query = "SELECT first_name, last_name, email_address, username, password, last_login FROM users WHERE first_name = '$first_name'";
$result = mysql_query($query);
$query_data = mysql_fetch_array($result);
$password = $query_dataї"password"];
$email = $query_dataї"email_address"];
if ($submit) {
// Updated Settings
$new_password = $_POSTї'new_password'];
$new_email = $_POSTї'new_email'];
if($new_passowrd) {
mysql_query("UPDATE users SET password='$new_password' WHERE first_name='$first_name'");
echo "<center><font color='red'>Password Updated.</font></center>";
setcookie("EwaldGroup_Password", $password, time()-9999);
}
if($new_email) {
mysql_query("UPDATE users SET email_address='$new_email' WHERE first_name='$first_name'");
echo "<center><font color='red'>Email Address Updated.</font></center>";
}
}
?>-Michael Ewald