using array_intersect

Question

I have 2 tables. One with a list of businesses and their addresses the other with a list of zip codes and their longitude and latitude. I have a form that accepts a zip code and a number of miles to check radius.

all the radius stuff works from a script i found online. what I need is to echo the entries of businesses that are within the radius.

So far i have 2 queries. one gets all entries zip codes inside the db the other get all zipcodes within the range i put in the form

i'm using array_intersect to find the matching ones. my problem is it only returns the first entry found. I'm SURE i need a while loop to do this but i have no idea how to do it.

code snippet:

     $insideRadius = array_intersect($data, $zipArray);

The $data is all the zip codes from the business table. the $zip array is all the zip codes within range.

I might be missing something but if you only have coordinates for the zip codes (and not the businesses and addresses) how are you going to find out which ones are within x miles of ... wherever — Vatev
– Vatev, Commented Jul 23, 2012 at 19:35
the table with long and lat also have the zip code. sorry if i didn't say that — Devin Prejean
– Devin Prejean, Commented Jul 23, 2012 at 19:36
yes i guess i need them to join on zip code... there was just a comment here and it worked "SELECT * FROM entries WHERE zip in (".implode(",",$zipArray) . ")"; — Devin Prejean
– Devin Prejean, Commented Jul 23, 2012 at 19:41

huysentruitw · Accepted Answer · 2012-07-23 19:52:13Z

2

Can't you just select the businesses that have a zipcode listed in the $zipArray?

"SELECT * FROM business WHERE zipcode IN (" . implode(",", $zipArray) . ")"

In PHP you could run it like this:

$result = mysql_query("SELECT * FROM business WHERE zipcode IN (" . implode(",", $zipArray) . ")");
while ($row = mysql_fetch_assoc($result))
{
    echo $row["name"] . "<br />";
    echo $row["zipcode"] . "<br />";
}

edited Jul 23, 2012 at 19:52

answered Jul 23, 2012 at 19:37

huysentruitw

28.2k10 gold badges95 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Devin Prejean Over a year ago

Yes that worked but it only gave me 1 entry back i have 2 entries in my table. 2 zipcodes that are within 5 miles of each other and only the first one that the query matches is displayed.

huysentruitw Over a year ago

If you execute this query, you must loop through the results. You can only fetch one row in each iteration. Can you try this query, and if it doesn't work, post your PHP code that executes the query and loops throug the results.

Vatev Over a year ago

try running it manualy from some MySQL client (like SELECT * FROM business WHERE zipcode IN (100,200,300)) to check if the problem is in the query or somewhere in your php code.

huysentruitw Over a year ago

@DevinPrejean: you mean the $zipArray? Can you add the output of the print_r($zipArray) to your question?

Devin Prejean Over a year ago

i ran it manually and it still only pulls the first one. i do need a while loop i'm sure. i need to go figure that out i don't want to sound like a total noob but i forget things fast if i haven't done them in a while. i have been writing php code for a year or so now.

|

Collectives™ on Stack Overflow

using array_intersect

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related