qualcuno mi puo dire dove svaglio......
connessionedb.php

codice:
<?php
$host="ip dell server "; // Host name 
$username="nome utente"; // Mysql username 
$password="password"; // Mysql password 
$db_name="nome database"; // Database name 
$tbl_name="user"; // Table name 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from form 
$myusername=$_POST['myusername']; 
$mypassword=$_POST['mypassword']; 

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "data_insert.php"
session_register("myusername");
session_register("mypassword"); 
header("location:data_insert.php");
}
else {
echo "Wrong Username or Password";

}
?>

mi viene fuori l'errore:


codice:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.miosito.it/home/test/connessionedb.php on line 26
Wrong Username or Password You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '', 'email@email.it')' at line 11