Help-MySQL resource error

[jowatkins]

Can anyone tel me what's wrong with the following script. I keep getting "Supplied argument is not a valid MySQL result resource". I've tried all kinds but I don't get it!!

$chk_result = mysql_query("SELECT * FROM active_users WHERE username = '$valid_user");
if (mysql_num_rows($chk_result) <1)
{
$login_result = mysql_query("INSERT INTO active_users (username, lastaction) VALUES ('$username', NOW(''))");
}

[Anon]

This bits wrong
WHERE username = '$valid_user");
should be
WHERE username = '$valid_user'");

[jowatkins]

Thanks so much, you've no udea how much time I've spent on this and didn't spot something so simple.