MySql error Message

[alisam]

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

[mikeq]

In your SQL statement use single quotes ' not double quotes " that way you wont have to add \ and this makes it more readable.

You don't need to escape the " in

$data["Password"];

[Anon]

echo out both the query string $sql and mysql_error(). Putting the two together should give you your answer.

I suspect the query string is wrong, the query is failing and therefore $result is not a valid query result id. Then mysql_fetch_array() will fail.

Cheers,

Cris

[alisam]

i tried ti scho the $sql and it echos:

SELECT Passwort FROM Friends WHERE Name='ali'

I think it should work, but it does not....
I really don't know where to look for help... please think about this once more

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

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

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

thanks in advance ali

[Anon]

Well, it sure looks like the query is ok.

Have you run the exact query through command line or phpmyadmin? Just to be sure the query string WILL return data?

Also, what is the exact error message you get?

Cheers,

Cris

[alisam]

the eroor message is exactly:

No Database Selected

ali

[crislewis]

The select the database:

if (!mysql_select_db('database name') die ("unable to select database");

It's odd but sometimes mysql doesn't work logically. It hase defaults all over the place but assuming a default database doesn't happen, even when you only have one.

Cris