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

[reyeskai]

Please help me i having this problem,
Current is my code:

error at line "if(mysql_num_rows($result)!=0)"


function getNewID($init,$field,$table)
    {
        $num = rand(1,100000000);

        $act_id = $init.$num;

        $query = "SELECT $field FROM $table WHERE $field = '$act_id'";
        $result = mysql_db_query("ssimage_db", $query);

            if(mysql_num_rows($result)!=0)
        { $exist = true; }
        else{ $exist = false; }

        while($exist)
        {
            $num = rand(1,100000000);

            $act_id = "$init".$num;

            $query = "SELECT $field FROM $table WHERE $field = '$act_id'";
            $result = mysql_db_query("ssimage_db", $query);
            if(mysql_num_rows($result)!=0)
            {
                $exist = true;
            }
            else
            {
                $exist = false;
            }
        }
        return $act_id;
    }

[Matthew N.]

There is a thread specially about this kind of error: http://www.daniweb.com/web-development/php/threads/191031

If that doesn't help, post what the error says in full.