tweeking

[Anon]

What's wrong on line 10?

<?
session_start();
if ($username && $passwd)
{
// if the user has tried to login
$db = mysql_connect("LOCALHOST","NAME","PASS");
mysql_select_db("http_auth", $db);
$query = "SELECT * FROM http_auth WHERE name='$username' AND passwd=password('$passwd')";
$result = mysql_query($query, $db);
if (mysql_numrows($result) >0 )
{
// if they are indeed in the database register the username
$valid_user = '$username';
session_register("valid_user");
}
}

[mdmann]

mysql_num_rows not mysql_numrows

[Anon]

I changed that.. it's still not working.

[toma42]

are your table and database really named the same?

[mdmann]

Are you getting an error message, or is
it not working the way you expected (and
how might that have been)?

[jc94062]

Check my answer to the post of mysql_num_rows below, very similar.