Partially. Once I find all the zip codes within an x-mile radius I
have to find all records in a db table that match any of those zip codes.
Load an array of zip codes within an x-mail radius, Let's assume
$ZipArray. Next.
$Subselect = "(" . implode('",",$ZipArray) , '")';
Let's additionally assume you have table "Members" with a field ZipCode
Then do
$Select = "SELECT * FROM Members WHERE ZipCode IN $Subselect";
which would expand to something like:
SELECT * FROM Members WHERE ZipCode IN ("08087","08088","08089")
Urb
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
