echo data from MySql

[alisam]

i have a little problem with data out of a MySql database. I correctly get the data out of the db, but when i assign a variable to the data and want to echo it, it does not work. Please tell me a way to fix that problem...

heres the code:

<?php

$verbindung = mysql_connect (\"xxx.xxx.xx\", \"xxx\", \"xxxx\");

mysql_select_db(\"xxxx\", $verbindung);

$sql = \"SELECT Passwort FROM friends WHERE Name=\'myself\'\" ;

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

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

mysql_close($verbindung);

echo $oldpass;

?>

thanks in advance

ali

[mithril]

The quick fix is, switch:

&nbsp;&nbsp;&nbsp;$data[\"Passwort\"] = $oldpass;

for this:

&nbsp;&nbsp;&nbsp;$oldpass .= $data[\"Passwort\"];

or this:

&nbsp;&nbsp;&nbsp;echo $data[\"Passwort\"] . "<br>";

HTH.

geoff