On PHPEasyStep.com, there's a new tutorial talking about adding "send forgotten password" functionality to your member site.
Mark Jackson is one of our member but he forgot his password for login to our website. We'll send him password to his e-mail address. In this tutorial create 2 file and 1 database - forgot_password.php, send_password_ac.php and the members database.
The rest of the tutorial is all code and SQL statements, including the HTML for the form the users fill out. Basically, it just grabs the password value from the database and sends it along in an email.
Of course, the structure is here for the application, but it's not very secure - sending the password in plain-text like that. Personally, I'd have md5 hashed passwords and reset the password to a new one each time the "request my password" was made. Then, they can come in and reset the paasword when they log in.