Forespørgsel til databasens informationer

Glemt brugernavn og kodeord, men kan huske email:
$query = "SELECT username, password FROM Users WHERE Users.mail = '$mail' LIMIT 1";
if(mysql_num_rows(query)==1)
{
    $row = mysql_fetch_assoc($query);
    $to = $mail;
    $subject = 'Glemt brugernavn / Adgangskode';
    $message  = "Brugernavn: " . $row['username'] . "\n";
    $message .= "Kodeord: " . $row['password'] . "\n";
   
    $headers =     "From: webmaster@{$_SERVER['SERVER_NAME']}\r\n" .
                        "Reply-To: webmaster@{$_SERVER['SERVER_NAME']}\r\n" .
                        "X-Mailer: PHP/" . phpversion();
   
    mail($to, $subject, $message, $headers);
}

Glemt kodeord, men kan huske brugernavn:
$query = "SELECT username, password, mail FROM Users WHERE Users.username = '$username' LIMIT 1";
if(mysql_num_rows(query)==1)
{
    $row = mysql_fetch_assoc($query);
    $to = $row['mail'];
    $subject = 'Glemt Adgangskode';
    $message  = "Brugernavn: " . $row['username'] . "\n";
    $message .= "Kodeord: " . $row['password'] . "\n";
   
    $headers =     "From: webmaster@{$_SERVER['SERVER_NAME']}\r\n" .
                        "Reply-To: webmaster@{$_SERVER['SERVER_NAME']}\r\n" .
                        "X-Mailer: PHP/" . phpversion();
   
    mail($to, $subject, $message, $headers);
}

takker, men har brugt noget andet:

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$emailadresse=$_POST['mail'];

$query = "SELECT username, password FROM Users WHERE Users.mail = '$emailadresse'";

$result = mysql_query($query);

$num = mysql_numrows($result);

mysql_close();

$name=mysql_result($result,0,"username");
$pwd=mysql_result($result,0,"password");

$to = $emailadresse;
$subject = 'Glemt brugernavn / Adgangskode';
$message = 'Brugernavn: '. $name. '  Password: '.$pwd;

//mail($to, $subject, $message);
if($num>0)
{
    if (mail($to, $subject, $message))
    {
        echo "Brugernavn / Adgangsko...........

Den er fino.