Warning: mysql_num_rows()...

mgway · July 8th, 2005, 07:33 PM

Code:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

I get that when trying to use the /textbook/ code for "auth_user.php". I don't get what the problem is there. It can connect to the database perfectly fine in the other scripts, but not this mission critical login page.

Any help would be appreciated.

rajuru · July 11th, 2005, 05:29 AM

Hi mgway,

for using this function you need a successful query resource to mysql like
$sql=mysql_query("SELECT * from table");
$rows=mysql_num_rows($sql);
echo $rows

you can check if your query syntax is correct while quering to mysql like
if(!$sql=mysql_query("SELECT * from table")) die(mysql_error());

this will notify you what error occurs when you quering to mysql. for more help give your codes sample?

Best Regard:
Md. Zakir Hossain (Raju)
www.rubd.net
www.xenexbd.com
Cheap Hosting, Domain, Reseller
www.forum.rubd.net

mgway · July 11th, 2005, 07:04 PM

Code:

<? 
}
function auth_user($userid, $userpassword){
    global $default_dbname, $user_tablename;

    $link_id = db_connect($default_dbname);

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

    if(!mysql_num_rows($result)){
        return NULL;
    }else{
        $query_data = mysql_fetch_row($result);
        return $query_data[1];
    }
}
?>

mgway · July 11th, 2005, 07:17 PM

Oi. Nevermind then.
I figured out my problem. I didn't define "$user_tablename" and didn't include a $ before "userpassword"
Thanks for your time. =)