Little code help

[Anon]

I am trying to verify a user name and password in my headers to decide which page they will go too. I have this code-

$Query = "SELECT count(*) from $TableName where user_logname='$name' AND user_password='$password'";
$Result = mysql_db_query($DBName, $Query, $Link);
$count=mysql_result($Result,0,0);
if($count==1){
header("Location:myaccount.php");}
else{
header("Location:login.php");}

The problem is that if you type in the right login name, it enters my account even if the password is left blank or wrong. I can't understand why its letting them in myaccount when they don't enter the right password because I put where user_logname='$name' AND user_password='$password', with that statement, it doesn't seem possible for them to enter the account with the wrong password. Anyone have any ideas? Or maybe a different way to code that?

Thanks a lot for any help.

[Anon]

Here's how I would do it.

$Query = mysql_query("SELECT * FROM $TableName WHERE user_logname='$name' AND user_password='$password'");
$count= mysql_num_rows($Query);
if ($count == 1) {
..code here
} else {
code here
}

I am sure you can do this with count() in your SQL and then check the return value. I don't know if either method is better.

[Anon]

"select count(*) from $TableName" will return a table with one row and one field whith the count of how many results the last select would have returned.

so $count will always be 1.

You can try this. Didnt test it, but should work.
<?php
$Query = "SELECT * from $TableName where user_logname='$name' AND user_password='$password'";
mysql_db_query($DBName, $Query, $Link);
$count = mysql_affected_rows();
if($count==1){
header("Location:myaccount.php");}
else{
header("Location:login.php");}
?>