--- In php-objects@xxxxxxxxxxxxxxx, "doneatlast1000" <doneatlast1000@...> wrote: > > 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[pwquestion]; > $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 > { > > $pass=$row[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 > } > } > in $pass=$row[pass]; line try to change like this $pass=$row['pass'];