[Resolved] [Resolved] Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result re

[Paragon]

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

function disp_refer() { 
   mysql_pconnect("$host","$username","$userpass"); 
   mysql_select_db("$userdatabase"); 
    $limit   ="10";   // How many referers to show. 
   $sql = "select * from $refersprefix order by id DESC Limit $limit"; 
   $query = mysql_query($sql); 
   while($result=mysql_fetch_assoc($query)) 
   { 
            $refdom = chop($result[url]);            //  chop trailing whitespace 
            $t       = parse_url($refdom); 
            $ref    = $t['host'];                    //  extract domain name from string 

echo "<A href='$ref' target='_blank'>$ref</A><BR>"; 

} }

[LordShryku]

Where is $refersprefix getting defined?

[Paragon]

In a config file. I tested it with the actual vaule of the table and it didn't work either way.

[LordShryku]

Then start debugging. As far as I see, that variable is never passed to the function, so it doesn't know what is it. But add mysql_error() in there

$query = mysql_query($sql) or die (mysql_error()."<br><br>".$sql);

[Paragon]

Just my mistake of not including the config in the function. Thanks for your help.