Posted by Ace on 08/25/05 19:39

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?

• Next in forum: What do I have to with this file??
• Prev in forum: Re: newbie question
• Thread view: MySQL on Win2k Advanced server not returning certain records

[Reply to this message]