Aha! John, you're right. I remember stumbling over this the first time I
used it. Sorry for any confusion,  Ehab.

More info here:
http://www.php.net/manual/en/function.mysql-result.php

-----Original Message-----
From: John Coder [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 2:09 PM
To: Ehab El Maraghy
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] a newbie in deep need for help


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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to