Error Help!

[Anon]

I keep getting tis error with mysql, does anyone know why? i believe i am putting the correct code in.

---

Warning: Supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\AI-RPG\access_logger.php on line 64

---

$link_id = db_connect($default_dbname);
$query = "SELECT username FROM $user_tablename
WHERE userid = '$userid'
AND userpassword = password('$userpassword')";
$result = mysql_query($query);

if(!mysql_num_rows($result)) {
session_unregister("userid");
session_unregister("userpassword");

[Anon]

since userid is probably a number, try it w/o the quotes. like so:

$query = "SELECT username FROM $user_tablename
WHERE userid = $userid
AND userpassword = password('$userpassword')";