On Fri, 2002-12-27 at 04:19, Ehab El Maraghy wrote: > Hi everybody > I have installed php4 and mysql on IIs winxp > I am trying to retrieve a password and print it using a query which is > written as followos > > $query2 = "select passwd from user where username = '$username'"; > $result = mysql_result($query2); > echo "<center><B>Old Password was $result </B></center>"; > > am I using mysql_result right or is there another function to print this > password taking in consideration that it just prints "Old Password was" and > that's it > If I'm not mistaken mysql_result() takes 3 arguments. try:
$select = "select passwd from user where username = '$username'"; $query2 = mysql_query($select); $result=mysql_result($query2,0,0); //the zeroes being the position of row and column i.e. row0 and column 0 echo $result; John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php