php help_connecting sql database

[ma5ect]

Hi,

 

I 'am trying to connect my sql database with my webpage for users log in. i have got this script so far but i keep getting the following error message which i cannot figure out..

 

could any1 help..

 

error:Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\checklogin.php on line 18

Wrong Username or Password

 

code:

<?

 

$hostname_mysql_connect = "localhost";

$database_mysql_connect = "website_members";

$username_mysql_connect = "root";

$password_mysql_connect = "******";

$tblname_mysql_connect ="members";

 

$mysql_connect = mysql_pconnect($hostname_mysql_connect, $username_mysql_connect, $password_mysql_connect, $tblname_mysql_connect) or trigger_error(mysql_error(),E_USER_ERROR);

mysql_select_db($database_mysql_connect) or die(mysql_error());

 

$myusername = $_POST['myusername'];

$mypassword = $_POST['mypassword'];

 

$sql = "SELECT * FROM $tblname_mysql_connect WHERE username= '$myusername' and password='$mypassword'";

$result = mysql_query($sql);

 

$count = mysql_num_rows($result); (line 18)

if($count==1) {

session_register("myusername");

session_register("mypassword");

header("location:login_success.php");

}

else {

echo "Wrong Username or Password";

}

 

?>

 

 

many thanx

 

[webent]

Looks ok from what I can tell, but I know mysql_num_rows is finicky... but I would try taking out the line space between these two lines... See what happens...

 

$result = mysql_query($sql);
$count = mysql_num_rows($result);

[PFMaBiSmAd]

This thread is a double-post to one in the php forum.

 

This error means the mysql_query() failed but the code blindly attempted to access a non-existent result resource.