Forgot password email only code tweak help

1

I have a working flash and php script combo that works in sending user and password info via requests for forgotton passwords.

I did not build it and my skill is limited. I only want the user to submit thier email and then the script sends user the password to thier email. or send both user and a password as is now…but the only requirment is email.

Currently user has to submit user both user name and email… I only want email reqirment. Can someone look at the code and help me out a bit? FLASH AND PHP CODE BELOW.

php is:

<?php
include(“conn.php”);

$success = 1;

$username = $HTTP_POST_VARS[‘username’];
$email = $HTTP_POST_VARS[‘email’];

$sql = “SELECT vchPassWord FROM tUser WHERE vchUserName = '”.$username."’ AND vchEmail = ‘".$email."’";

$rs = mysql_query($sql, $conn) or die(mysql_error());
$row = mysql_fetch_assoc($rs);

if(!$row){
//The user dont exists
$success = 0;
$msg = ‘The user doesn´t exists or the username and e-mail don´t match.’;
echo ‘&success=’.$success.’&msg=’.$msg.’&’;
} else {
//The user exists
$password = $row[“vchPassWord”];

$subject = "Your MyCompany.com user information";
$message = "Here is your user information for MyCompany.com:

";
$message .= "Username: “.$username.”
";
$message .= "Password: “.$password.”
";
$message .= "E-mail: “.$email.”

";
$message .= "Log on to: http://www.mycompany
";
$footer = “From: MyCompany.com”;

$formsent = mail($email, $subject, $message, $footer);

if($formsent == 1) {
    $msg = "Thank you, your password has been sent to ".$email;
} else {
    $success = 0;
    $msg = "We are sorry, but your password could not be sent to ".$email;
}
echo '&success='.$success.'&msg='.$msg.'&';

}

mysql_close($conn);

?>

flash is:

Selection.setFocus(inpUserName);
this.inpUserName.tabIndex = 0;
this.inpEmail.tabIndex = 1;

this.btnSubmit.onRelease = function(){
this._parent.submit();
}

this.btnClose.onRelease = function(){
gRoot.loadContent(“home.swf”, null, false);
}

function submit(){
if(this.inpUserName.text != “” && this.inpEmail.text != “”){
if(gRoot.checkEmail(this.inpEmail.text)){
this.txtResponse.text = “Sending message…”;
var tVars = new LoadVars();
tVars.owner = this;
tVars.username = this.inpUserName.text;
tVars.email = this.inpEmail.text;
tVars.onLoad = function(){
this.owner.txtResponse.text = this.msg;
}
tVars.sendAndLoad(gSystemPath + “forgot_password.php”, tVars, “POST”);
} else {
this.txtResponse.text = “Please enter a valid email address.”;
}
} else {
this.txtResponse.text = “Please fill in all fields and try again.”;
}
}

stop();

Any help would be greatly appreciated.

Thank you

m.