while the user entering the username and password if he forget password he wants to click the forget password link and he wants to get the new password by entering his emailid and username, so that he receive the new password in his mailid, if any body knows coding for this send me
that would be very long coding. I am making classes for the purpose for my website. If you want to buy them let me know.
There are many tutorials available for this. Long coding, lol! Do a little research and use google to find what you need. This is one of the simple tasks an admin of a site must handle.
hmm dvd is right i read your post wrong. I thought you wanted an entire administrator script. For this you just need to use SELECT password FROM table WHERE email=$email and then send what is returned via mail() to the person. Just substitute the table with the table you have in your database which contains the member information. And the variable $email should contain the email the user enters through a form you present which asks for the email of the person who wants to retrieve their password. That's it.