Even this $row=mysql_fetch_assoc($check); in the script could not solve the problem of echoing out the password set in the $pass variable, but if you use any other variable like $fname it give you the appriopriate result. Still battling to fix it Thanks, Gab --- On Thu, 1/14/10, bahalul kabir <bahar_aub@xxxxxxxxx> wrote: From: bahalul kabir <bahar_aub@xxxxxxxxx> Subject: Re: Retrieving password from database To: php-objects@xxxxxxxxxxxxxxx Date: Thursday, January 14, 2010, 7:56 AM Sorry ! Joe ____________ _________ _________ __ From: Joe Forsythe <jforsythe@mosaiccre ative.com> To: php-objects@ yahoogroups. com Sent: Wed, January 13, 2010 6:38:29 PM Subject: Re: Retrieving password from database Was that directed at me? I assume so, since you replied to me rather than doneatlast. If so, that line of code is not in there. Maybe you meant that doneatlast needs to include that line of code? -- Joe On Jan 13, 2010, at 11:32 AM, bahalul kabir wrote: > You missed > $row=mysql_fetch_ assoc($check) ; > > ____________ _________ _________ __ > From: Joe Forsythe <jforsythe@mosaiccre ative.com> > To: php-objects@ yahoogroups. com > Sent: Wed, January 13, 2010 4:22:58 PM > Subject: Re: Retrieving password from database > > Unless I've missed it somewhere, $row[pass] doesn't really do > anything. You're just setting $pass to another variable that does > nothing. > -- > Joe > > On Jan 13, 2010, at 7:06 AM, 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[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 > > { > > > > $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 > > } > > } > > ?> > > > > > > [Non-text portions of this message have been removed] > > ------------ --------- --------- ------ > > Are you looking for a PHP job? > Join the PHP Professionals directory Now! > http://www.phpclass es.org/jobs/ > Yahoo! Groups Links > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] ------------ --------- --------- ------ Are you looking for a PHP job? Join the PHP Professionals directory Now! http://www.phpclass es.org/jobs/ Yahoo! Groups Links [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]