$host="ksala.db.10118637.1b1.hostedresource.net"; // Host name
$username="ksala"; // mysql username
$password="OrientOfLouisiana@1"; // mysql password
$db_name="ksala"; // Database name
//Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");
// value sent from form
$email_to=$_POST['email_to'];
// table name
$tbl_name=members;
// retrieve password from table where e-mail = $email_to(mark@phpeasystep.com)
//BOTH sql statements below work
//$sql="SELECT memberemail, memberpassword FROM sublodges WHERE memberemail = '$email_to'";
$sql="SELECT memberemail, memberpassword FROM sublodges WHERE memberemail = '".$_POST['email_to']."'";
$result=mysql_query($sql);
// if found this e-mail address, row must be 1 row
// keep value in variable name "$count"
$count=mysql_num_rows($result);
// compare if $count =1 row
if($count==1){
$rows=mysql_fetch_array($result);
// keep password in $your_password
$your_password=$rows['memberpassword'];
// ---------------- SEND MAIL FORM ----------------
// send e-mail to ...
$to=$email_to;
// Your subject
$subject="LodgeHelper System Lost Password";
// From
//$headers = 'From: admin@giuseppeinc.net' . "\r\n" .
$headers .= 'From: MyLodgehelper HelpDesk
";
}
// if your email succesfully sent
if($sentmail){
echo "If you need further assistance, please call us at 714.805.9OTS (9687)";
}
else {
echo " ";
}
?>

