MySql Select from

[Anon]

I have a table on my MySql db which is called 'friends'. There a 4 fields on that table called name, password, telnumber and status.

Now i want to select the password from a friend called John and echo this password. How can i do this using PHP ?
(please tell me how the syntax of the MySql query is in such cases)

Thanks in advance

ali

[Anon]

<?php

$sql = "SELECT password FROM friends WHERE name = \"john\""

$result = mysql_query($sql);

while ($data = mysql_fetch_array($result))
{
echo $data["password"];
}

?>

give it a go

[khaine]

where uname is the username entered and pword is the password entered.

<?php

$connection = mysql_connect("localhost", "username", "secret")
    or die ("Could not connect");

$query = "SELECT * FROM friends where name=\"".$uname."\"";
$result = mysql_query ($query, $connection) or die ("Query failed");
$nums=mysql_numrows($result);

if ( $nums > 0 )
{
    $row=mysql_fetch_array($result);
    $name=$row['name'];
    $password=$row['password'];
    $telnumber=$row['telnumber'];
    $status=$row['status'];
    if ( $password == $pword )
    {
        echo "login successfull"; 
    }
    else
    {
        echo "login unsuccessfull"; 
    }
}
else
{
    echo "Query failed who are you?");
}
mysql_close ($connection);

?>

Mark.