<?php

  $submit = $_POST['submit'];
  $email = $_POST['email'];

  if($submit)
  {

  include 'connect.php';

  $queryget = mysql_query("SELECT username FROM wiborg WHERE email='$email'");
  $row = mysql_fetch_assoc($queryget);
  $numrows = mysql_num_rows($queryget);

    if($numrows!=0)
    {

      $username = $row['username'];
      $newpassword = rand(23456789,98765432);
      $password = md5($newpassword);

      $querychange = mysql_query("UPDATE wiborg SET password='$password' WHERE username='$username'");

      $to = $email;
      $subject = "Aktivera ditt konto";
      $headers = "From: n.wiborg@gmail.com";
      $server = "smtp.bredband.net";

      ini_set("SMTP",$server);

      $body = "Hejsan! \n\n Här kommer dina användaruppgifter:\n Användarnamn: $username \n Genererat lösenord: $newpassword \n Logga in och ändra det snarast.";

      mail($to, $subject, $body, $headers);

      die("Dina användaruppgifter har nu skickats till din e-post.");

    }
    else
      die("E-postadressen existerar inte.");

  }


  else
    echo "<form action='index.php?page=forgot' method='POST'>

            <table>