$email=$_POST['email'];
$email=mysql_real_escape_string($email);
$status = "OK";
$msg="";
//error_reporting(E_ERROR | E_PARSE | E_CORE_ERROR);
// You can supress the error message by un commenting the above line
if (!stristr($email,"@") OR !stristr($email,".")) {
$msg="Your email address is not correct<BR>";
$status= "NOTOK";}




echo "<br><br>";
if($status=="OK"){ // validation passed now we will check the tables
$query="SELECT email,userid,password FROM plus_signup WHERE plus_signup.email = '$email'";
$st=mysql_query($query);
$recs=mysql_num_rows($st);
$row=mysql_fetch_object($st);
$em=$row->email;// email is stored to a variable
if ($recs == 0) { // No records returned, so no email address in our table
// let us show the error message
echo "<center><font face='Verdana' size='2' color=red><b>No Password</b><br> Sorry Your address is not there in our database . You can signup and login to use our site. <BR><BR><a href='signup.php'> Sign UP </a> </center>";
exit;}


// formating the mail posting
// headers here
$headers4="[email protected]"; // Change this address within quotes to your address
$headers.="Reply-to: $headers4\n";
$headers .= "From: $headers4\n";
$headers .= "Errors-to: $headers4\n";
//$headers = "Content-Type: text/html; charset=iso-8859-1\n".$headers;
// for html mail un-comment the above line


// mail funciton will return true if it is successful
if(mail("$em","Your Request for login details","This is in response to your request for login detailst at site_name \n \nLogin ID: $row->userid \n Password: $row->password \n\n Thank You \n \n siteadmin","$headers")){echo "<center><font face='Verdana' size='2' ><b>THANK YOU</b> <br>Your password is posted to your emil address . Please check your mail after some time. </center>";}


else{// there is a system problem in sending mail
echo " <center><font face='Verdana' size='2' color=red >There is some system problem in sending login details to your address. Please contact site-admin. <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}


}
else {// Validation failed so show the error message
echo "<center><font face='Verdana' size='2' color=red >$msg <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}

<div id="center">
                                 <form method="post" action="./?p=algemeen-gbkwijt" name="sendUser">
<table width="100%" cellspacing="0" cellpadding="0">
 <tr>
  <td class="titel" colspan="2">Bulletstar - Gebruikersnaam kwijt</td>
 </tr>
  <tr>
   <td class="tekst" colspan="2">
    <img src="./bulletstar-icons/table_relationship.png" /> <font color="#00FF00"><b>Gebruikersnaam kwijt</b></font>
    <br />Je bent je gebruikersnaam vergeten? Of weet niet meer hoe je jezelf hebt geregistreerd?<br />Via deze pagina kun je dat na-checken.
    <br /><br />
    <font color="red"><em>Misbruik van deze functie word <u>zwaar</u> bestraft!</em></font>
   </td>
  </tr>
  <tr>
   <td class="titel1" align="left" colspan="2">
    Gebruikersnaam opvragen
   </td>
  </tr>
<?
if(isset($_POST['sendUser']))
{
     $email = mysql_query("SELECT * FROM `users` WHERE `email`='".$_POST['email']."'");
          if(preg_match('/^.+@.+\..+$/',$_POST['email']))
          {
     if(mysql_num_rows($email) > 0)
     {
                                $user = mysql_fetch_object($email);
                                $sitelink      = str_replace("www.","",$_SERVER["SERVER_NAME"]);
                                $replace       = substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1);
                                $path          = str_replace($replace, "", $_SERVER["SCRIPT_NAME"]);
                                if($path == ""){                $path          = "/";}
			$headers	=	'MIME-Version: 1.0' . "\r\n";
			$headers	.=	'Content-type: text/html; charset=iso-8859-1' . "\r\n";
			$headers	.=	"From: {$sitelink} <admin@{$sitelink}>" . "\r\n";
mail($_POST['email']," Bulletstar - Gebruikersnaam","
Er is zojuist een aanvraag binnengekomen om je gebruikersnaam even per e-mail te sturen.<br />
Onder dit email adres staat de volgende gebruiker geregistreerd: ".$user->login."<br /><br />


Deze aanvraag is gedaan door {$_SERVER['REMOTE_ADDR']}<br /><br />


Met vriendelijke groet,<br /><br />


Bulletstar Helpdesk<br />
http://www.{$sitelink}","$headers");
                                    echo"  <tr><td class=\"tekst2\" colspan=\"2\"><img src=\"./bulletstar-icons/tick.png\" /> Er is zojuist een e-mail verzonden!</td></tr>";
          }
               else
                   {
                       echo"  <tr><td class=\"tekst2\" colspan=\"2\"><img src=\"./bulletstar-icons/error.png\" /> Het ingevoerde e-mail adres is niet ingebruik!</td></tr>";
                   }
     }
     else
         {
             echo"  <tr><td class=\"tekst2\" colspan=\"2\"><img src=\"./bulletstar-icons/error.png\" /> Het ingevoerde e-mail adres is ongeldig!</td></tr>";
         }
}
?>
    <tr>
   <td class="tekst" width="35%">
    <img src="./bulletstar-icons/email_link.png" /> <b>E-mail adres:</b>
   </td>
   <td class="tekst2" width="65%">
    <input type="text" name="email" style="width: 195px;">
   </td>
  </tr>
  <tr>
   <td class="tekst" colspan="2">
    <img src="./bulletstar-icons/tick.png" /> <input type="submit" name="sendUser" value="Stuur gebruikersnaam op!" style="width: 170px; cursor: pointer;">
   </td>
  </tr>
 <tr>
  <td class="titel" colspan="2">&nbsp;</td>
 </tr>
</table>
</form>
		   	  </div>