Olaf Lederer - 2005-11-23 07:43:40 -
In reply to message 1 from matthijs
Hello,
I see the problem:
$sql = sprintf("SELECT ip2nationCountries.country AS variable, COUNT(*) AS value FROM %s AS tbl LEFT JOIN ip2nationCountries ON ip2nationCountries.code = tbl.country WHERE tbl.country <> '' GROUP BY tbl.country ORDER BY 2 DESC LIMIT 0,%s", $this->table_name, $limit);
The table names (uppercase C) are different (script en sql data);
I will fix this with the next update.
Olaf