It depends how you've stored the password.
Normally (probably) the password is stored in a database, but it has been encrypted using md5() . In this case, you can't get the password back. What you'd have to do is to automatically generate a password, send it, encrypt it with md5(), then store it. You can then let the user change the password again.
If it's just stored as is in the database or whatever, it's pretty simple to pull it out and send it to the associated email. Normally though, it isn't the best idea to keep it just as it is in the database, as it is pretty simple for someone who's not that trustworthy to go grabbing everyone's passwords and then screw everything up.
Will