MySql Select

[Anon]

I want to select the password from a friend from my db and echo it. I tried following:

$verbindung = mysql_connect ("mysql.myhost.net", "xxx", "xxxx")

   or die ("Unable to connect to Database");

$sql = "SELECT Password FROM Friends WHERE Name=\"ali\"" ;
$result = mysql_query($sql);
while($data = mysql_fetch_array($result))
{
echo $data["Password"];
}

But the Interpreter tells me an MySql error on following line:

while($data = mysql_fetch_array($result))

I don't no what is wrong with that script. Please help

regards ali

PS: The table is called Friends the Field are named Password, Name etc...

[junebug]

add this if statement after your query to return the error message if query fails:

if(!$result){
print mysql_error();
die();
}

also, try your query like this:

$sql = "select Password from Friends where name = 'ali'";

[alisam]

my srcipt:

$verbindung = mysql_connect ("mysql.xxx.xx", "xxxx", "xxxx")
or die ("Unable to connect to Database");
$sql = "SELECT Passwort FROM Friends WHERE Name='ali'" ;
$result = mysql_query($sql);

if(!$result){
print mysql_error();
die();
}

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

the error no database selected.

But i have specified the database in the first line (in $verbindung)

please help...

ali

[khaine]

try using.

$result = mysql_query($sql, $verbindung);

Mark.

[alisam]

still says no db selected

ali

[Anon]

Yes. that is the way to do. please use that and your problem is over

[Anon]

afasdas a dasd asdasd asdasd asd asdas asd asdas asd asdas