•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 375,219 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,276 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 295 | Replies: 0
 |
•
•
Join Date: Jun 2005
Location: USA
Posts: 147
Reputation: 
Rep Power: 4
Solved Threads: 1
Junior Poster
Hello,
I am using a GeoLite Country ip csv and storing it in the db.
it contains ip numbers which are normally huge.
My problems comes when I search for some of these numbers.
my query:
This query works fine but, the problem is that some of the numbers I get from the database are a lot smaller then 1213099967 which does not make sense to me.
Please share any opinions.
I am using a GeoLite Country ip csv and storing it in the db.
it contains ip numbers which are normally huge.
My problems comes when I search for some of these numbers.
my query:
SELECT * FROM range WHERE range1 >= 1213099967
This query works fine but, the problem is that some of the numbers I get from the database are a lot smaller then 1213099967 which does not make sense to me.
Please share any opinions.
Host Gator
Cheap reliable hosting Click Here
Cheap reliable hosting Click Here
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Similar Threads
- Popups even with popup blocker and site redirection (Viruses, Spyware and other Nasties)
- Popup blocker for Opera? (Windows Software)
- Windows 2000 problem (Windows NT / 2000 / XP / 2003)
- weird IE6 problem (Web Browsers)
- Ok, Crunchie, one more bridge.dll problem (Viruses, Spyware and other Nasties)
- Aedin: (Yet Another) Rundll32 Error problem (Viruses, Spyware and other Nasties)
- Http:// takes me to Page Error (Web Browsers)
- IE Refresh problem, startnow.com causing problems (Web Browsers)
Other Threads in the MySQL Forum
- Previous Thread: small error with dates
- Next Thread: foreign keys
