num_rows

[Kudose]

Any ideas as to why this wouldnt work? Says invalid result resource...

[PHP
<?

include('dbinfo.inc.php');

$query = "SELCET * FROM users WHERE username='$username' AND password='$password'";
$rows = mysql_num_rows($query) or die(mysql_error());

if ($rows == '1') {
session_start();
session_register("username");
header("Location: secure.php");

} else {

echo" ACCESS DENIED! ";

}

?>
[/code]

THANKS!

[mahers]

You have to perform the query first.

$query = "SELCET * FROM users WHERE username='$username' AND password='$password'";
$result = mysql_query($query) or die(mysql_error());
$rows = mysql_num_rows($result) or die(mysql_error());

[Kudose]

THANKS!