Check red line below on u'r code ________________________________ From: doneatlast1000 <doneatlast1000@xxxxxxxxx> To: php-objects@xxxxxxxxxxxxxxx Sent: Wed, January 13, 2010 2:06:15 PM Subject: Retrieving password from database I write the script below for users to retrieve their password when forgotten, but the echo result is not brining out the password as it output: Your password is Can anyone look at the script below and help out. <?php if (!empty($_POST[ Submit])) { include ("connect.php" ); $pwquestion= $_POST[pwquestio n]; $pwanswer=$_ POST[pwanswer] ; $cityob=$_POST[ cityob]; $check=mysql_ query("SELECT * FROM register WHERE pwanswer='$pwanswer ' AND cityob='$cityob' "); if(mysql_num_ rows($check) ==0) echo "Invalid Check"; else { $row1=mysql_fetch_assoc($check) $pass=$row1[pass] ; $sel=mysql_query( "SELECT * FROM register WHERE pass='$pass' "); $row=mysql_fetch_ array($sel) ; echo "Your Password is <b>$pass</b> "; // The output is: Your Password is // I need the really password($pass) to be echo out } } ?> [Non-text portions of this message have been removed]