problemer med min update into db
Hej jeg har nogle problemer med at få min update funktion til at virke. kan i ikke hjælpe?!Her er koden der er problemer med.
<?
if($_GET['step'] == "1"){
$username = $_GET['username'];
$SQL = "SELECT * FROM wow_users WHERE username = '$username'";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
while ($Get = mysql_fetch_object($loadin)){
if($_POST['username'] == $Get->username && $_POST['email'] == $Get->email && $_POST['password'] != ""){ //-- ```````````````````````````````Subdomain Registration
$password = $_POST['password'];
$id = $Get->id
mysql_query("UPDATE `wow_users` SET `password` = MD5( '$password' ) WHERE `id` =$id LIMIT 1") or die (Java::Alert("MySQL Error: ".mysql_error()));
Java::Alert("Der er sendt en mail med de oplysninger du lige har indtastet.");
$to = $_POST['email'];
$subject = 'The Danish Force password retrival!';
$message = 'Vi har registeret at '.$_POST['username'].', har endret password til.<br><br>Brugernavn: '.$_POST['username'].' <br>Password: '.$_POST['password'].' <br><br><center>Fra Staff</center>';
$headers = "From: tdf@webhosteu.com\r\n" .
'X-Mailer: PHP/' . phpversion() . "\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-Type: text/html; charset=utf-8\r\n" .
"Content-Transfer-Encoding: 8bit\r\n\r\n";
mail($to, $subject, $message, $headers);
Java::GoToURL("http://thedanishforce.webhosteu.com");
}else{
Java::Alert("Husk at skrive i alle felter");
Java::GoToURL("http://thedanishforce.webhosteu.com/index.php?p=pages/getpassword");
}}
Db::Conn(close);
}
?>
