Re: Query missing rows in location of zip by distance

2006-09-25 Thread Steffan A. Cline
. Cline" <[EMAIL PROTECTED]> > Cc: MySQL List > Subject: Re: Query missing rows in location of zip by distance > > On Mon, 2006-09-25 at 06:09 -0700, Steffan A. Cline wrote: >> Basically all 6 should come up in the big query because they are within the >> same

Re: Query missing rows in location of zip by distance

2006-09-25 Thread Jay Pipes
On Mon, 2006-09-25 at 06:09 -0700, Steffan A. Cline wrote: > Basically all 6 should come up in the big query because they are within the > same zip and that any other locations within the same area. They all have > the same latitude and longitude but only 1 shows up. If they all have the same lat/

Query missing rows in location of zip by distance

2006-09-25 Thread Steffan A. Cline
Ran into a strange problem. In this zip code I am searching in I know for sure I have 6 locations within the 63385 zip. Doing a simple select * from locations where zip = '63385' returns 6 rows. Basically all 6 should come up in the big query because they are within the same zip and that any othe