note 47018 rejected from function.mysql-query by cece

From: Date: Sat, 30 Oct 2004 21:52:03 +0000
Subject: note 47018 rejected from function.mysql-query by cece
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-79376@lists.php.net to get a copy of this message
Note Submitter: marsteam at zoznam dot sk ---- Please help me, how can I make something like this: I have a registered users, but they some of them forgot their password. I need to make an automatic e-mail formular that will e-mail them password: I have done all, the main things are: $users_password = mysql_query("SELECT password FROM users WHERE email_address='$given_email'"); Email looks like: ----------- Hi, blablabla Your Pasword is: $users_password ----------- The main problem is that it looks like this: ----------- Hi, blablabla Your Pasword is: 1 ----------- How can I get that password from database when querry return only 0 or 1? Please help me, i am stunned.Thanks.

« previous php.notes (#79376) next »