Re: [PHP] [Followup] Exploding Zip Codes! (Using PHP's explode function)

2002-08-15 Thread Analysis & Solutions
On Tue, Aug 13, 2002 at 12:13:35PM -0700, Keith Posehn wrote: > > 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. > > SELECT * FROM [table] > WHERE zip="[all the darn zips listed here]" $qu

RE: [PHP] [Followup] Exploding Zip Codes! (Using PHP's explode function)

2002-08-13 Thread Michael Geier
are you trying to insert into MySQL DB? Or select out of the DB? insert: table structure: zip city etc... connect to db; loop through your array { //while ($array = array_shift($data)) create $sql from array parts ($sql = "insert i