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 (the slashes were added by php-builder server):

<?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

[jhonrputra]

Hi.

It's simple. I think you have made a mistake on :
$data["Passwort"] = $oldpass;

Since you want to assign the value of $data["Passwort"] to a variable named $oldpass, the correct command is:

$oldpass=$data["Passwort"];

Hope usefull.

[[deleted]]

I have no clue what you are trying to do, because it makes not sense. :-)

Here's what you are doing:

// Execute the query
$result = mysql_query($sql, $verbindung);

// While there are results, fetch the next result and put it in $data
while($data = mysql_fetch_array($result))
{
// Put the value of $oldpass in $data['Passwort']
// This means that you overwrite the query-results!!
$data[\"Passwort\"] = $oldpass;
}

// Close the database connection
mysql_close($verbindung);

// Print the value of $oldpass
echo $oldpass;

If you want to echo all the 'passwort' fields from your query, just do this:

result = mysql_query($sql, $verbindung);
while($data = mysql_fetch_array($result))
{
echo $data[\"Passwort\";
}

mysql_close($verbindung);