Page 1 of 1

proper SQL for Country on local

PostPosted: Wed Jan 28, 2009 4:05 pm
by XsTatiC
I looked at the local database. It seemed logical. To get a simple result for IP 66.249.71.1

Select countries.name from countries, ip4_66
WHERE b = '249'
and c = '71'
and ip4_66.country = countries.id

At least that's what I thought the query should be. That returns ANDORRA.

However I went to plugin that IP into here: http://www.hostip.info/index.html and end up with
IP address: 66.249.71.1
Location: Mountain View, CA, UNITED STATES

What is wrong with my query? Help would be greatly appreciated.

Thank you.

Gerry

I was getting to be a big boy

PostPosted: Sat Mar 21, 2009 5:16 pm
by qisolu359o
success grows out of struggles to overcome difficulties.

My neighborhood was a class-A advertisement for the postWorld War II baby boom. There were lots of young couples with kids. Across the street lived the most special child of all, Mitzi Polk, daughter of Minor and Margaret Polk. Mitzi had a loud roaring laugh. She would swing so high on her swing set the poles of the frame would come up out of the ground, as she bellowed at the top of her lungs, Billy sucks a bottle! Billy sucks a bottle! She drove me nuts. After all, I was getting to be a big boy and I did no such thing.

I later learned that Mitzi was developmentally disabled. The term wouldnt have meant anything to me then, but when I pushed to expand opportunities for the disabled as governor and President, I thought often of Mitzi Polk. Come and buy world of warcraft power leveling, cheap free wow power leveling web . warcraft gold webpage!

A lot happened to me while I lived on Thirteenth Street. I started school at Miss Marie Purkins School for Little Folks kindergarten, which I loved until I broke my leg one day jumping rope. And it wasnt even a moving rope. FFXI Gil The rope in the playground was tied at one end to a tree and at the other end to a swing set. The kids would line up on one side and take turns running and jumping over it. All the other kids cleared the rope.