Codice PHP:
<?php
$conn
=mysql_connect("localhost","root") or die(mysql_error());
mysql_select_db("mydb");
$querymysql_query("SELECT psw FROM user WHERE user='$user' ");
$psw mysql_result($query,0,'psw');
?>
se proprio vuoi usare mysql_fetch_row()
Codice PHP:
<?php
$conn
=mysql_connect("localhost","root") or die(mysql_error());
mysql_select_db("mydb");
$querymysql_query("SELECT psw FROM user WHERE user='$user' ");
$row mysql_fetch_row($query); // Supponendo user sia unico
echo $row[0];

?>