|
|
Posted by Simon Bridgewater on 08/28/05 10:38
does the same happen with a
select count(*) from ip2country WHERE IP_FROM <= 2113928215 and IP_TO
>=2113928215
LIMIT 0, 1;
have you run the query in mysqladmin or similar.?
"Ace" <admin@fsworld-dot-us.no-spam.invalid> wrote in message
news:XcGdnZ2dnZ3has2hnZ2dnXZZkt6dnZ2dRVn-yZ2dnZ0@snappydsl.net...
> I posted this message in alt.comp.databases.mysql however it does not
> seem to be such a busy newsgroup so I figured I may as well try
> here.
>
> Hi,
>
> I have just installed ip2country - This is a database consisting of
> 56000 records of IP address ranges. Typically the application checks
> a users IP address - converts it to long format then queries the
> database with the following query
>
> SELECT IP_FROM, IP_TO, COUNTRY_CODE2, COUNTRY_CODE3, COUNTRY_NAME FROM
> ip2country WHERE IP_FROM <= 2113928215 and IP_TO >=2113928215
> LIMIT 0, 1;
>
> The database then returns the country name , and country code of the
> IP address.
>
> Here is the problem.
>
> The query works, however if the record is past row 2709 - MySQL DOES
> NOT return the result! I.E it is only reading the first 2708 rows.
> Any result stored after that row is simply returning nothing.
>
> I have no idea why this would happen! can anyone perhaps help?
>
Navigation:
[Reply to this message]
|