il segunte codice dovrebbe fare l'accesso con user="pinco" e password="pallino"

però non funziona. infatti da sempre "utente non autorizzato". boh!

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>

<?php

if(isset($_POST['submit'])){
$user_form = $_POST['user'];
$pass_form = $_POST['pass'];

$host = "localhost";
$user = "root";
$database = "test";
$password = "";

$db = mysql_connect($host, $user, $password);

$query = "SELECT * from utenti WHERE user = '" . $user_form . "' AND pass ='" . $passform . "'";

mysql_select_db($database, $db);

$result = mysql_query($query, $db);

echo mysql_num_rows($result) . "
";

if (mysql_num_rows($result) > 0){
echo "utente autorizzato";
}

else
{
echo "utente non autorizzato";
}

}

?>
<form action="" method="post">
user: <input type="text" name="user" />


pass: <input type="text" name="pass" />


<input type="submit" name="submit" value="submit" />
</form>

</body>
</html>