I am not getting the data for the ip address 22.214.171.124 it's @ipnum coming to 3033990570. But when i checked it over the net it shows me City:Bangalore Region:Karnataka Country:India, but in the database no data for that.
And same happened with the ip address that you have used in your article that is 126.96.36.199 you have show a entry for that but with i am not getting it, i have used this query :-
declare @ip varchar(50), @ipnum bigint
set @ip = '188.8.131.52'
select @ipnum = dbo.ConvertIp2Num(@ip)
from [GeoLiteCity_blocks] blk (nolock)inner join [GeoLiteCity_location] loc (nolock)on blk.locId = loc.locId
where @ipnum between blk.startIpNum and blk.endIpNum
is this query right?
i ahve used the latest csv files.
please help i am really wanting to extract something new form this, but not getting the basic.
[font="Comic Sans MS"]Rahul:-P[/font]