[Followup] Exploding Zip Codes! (Using PHP's explode function)
| From: | Keith Posehn | Date: | Tue, 13 Aug 2002 19:13:35 +0000 |
| Subject: | [Followup] Exploding Zip Codes! (Using PHP's explode function) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-112410@lists.php.net to get a copy of this message | ||
Final question on this (I hope).
I have the code together now to put it all the zip codes into and array--but
now I need to add those zip codes to a sql statement for the WHERE clause.
Example:
SELECT * FROM [table]
WHERE zip="[all the darn zips listed here]"
(or something like that)
How would I set it to loop all the zip codes into this statement? I'm not
worried about the SQL syntax, I can figure that out without a problem, but
the php code is the question. This is in MySQL btw, and I have looked
through the docs there and at php for this, but need some help from all you
guru's out there.
Thanks for the help!
(Previous message here)
> I have a huge block of zip codes I need to seperate into their constituent
> parts for a query of a database. The block looks like this (in part):
>
> | 36310 ABBEVILLE |
> | 35440 ABERNANT |
> | 35005 ADAMSVILLE |
> | 35540 ADDISON |
> | 35006 ADGER |
> | 35441 AKRON |
>
> I need to use eplode (probably) to seperate this all out into two arrays,
> one of codes, the other of names--presumably named $zips[] and $cities[]
> with the rest of the data dumped.
>
> I have gone and looked at the various functions docs at php.net, but they
> haven't really helped to answer my question as much as I would like. Any
> information is appreciated.
>
> Thanks