Posted by Ace on 08/27/05 04:42

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?

• Next in forum: Re: Splitting strings, explode?
• Prev in forum: Re: Splitting strings, explode?
• Thread view: PHP <> MySQL on Win2k Advanced server not returning r

[Reply to this message]