condition = " WHERE franchisee_email = '".$franchisee_email."'"; $franchisee_ob->Reporttype = "allrecord"; $franchisee_res = $franchisee_ob->FetchRecords();//FUNCTION CALLED TO FETCH THE FRANCHISEE DETAIL $franchisee_tot= mysql_num_rows($franchisee_res); if($franchisee_tot > 0) { while($franchisee_data = mysql_fetch_array($franchisee_res)) { $franchisee_email = $franchisee_data[franchisee_email]; $franchisee_pass = $franchisee_data[franchisee_pass]; $franchisee_name = stripslashes($franchisee_data[franchisee_name]); //STORE THE SESSION VARIABLES $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: $webmaster_email \r\n"; //-----------------------------FORGOT PASSWORD MAIL FORMAT------------------------- $ebody="

Hello $franchisee_name, Here is the password you requested. Use this with your email, $franchisee_email, to login. Password: $franchisee_pass

"; $sub="Forgot password"; $to = $franchisee_email; mail($to, $sub, $ebody, $headers); } print ""; }else { $msg = "Sorry! No account matching this e-mail address was found. Please try again."; } } ?>

Please enter your email address and your password will be sent to that account. Email: