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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
