Selecting and sorting records by zipcode

[clay1]

I've got a table with profiles that I need to email to various people based on a list of zip codes provided

 

for example all profiles matching zip codes 1,2, and 3 will be emailed to 123@whatever and all profiles matching zips 4,5 and 6 will be emailed to a different email address.

 

If I grab all the appropriate records from the table with 1 query into an associative array what would be a good way to go through that array, parse the zipcodes and I suppose put them in a new array so that I can email them to the correct address?

 

[Catfish]

$sqlQuery = 'YOUR sql QUERY';
if ($recordResults = mysql_query($sqlQuery))
   while ($recordData = mysql_fetch_assoc($recordResults))
   {
      if ($recordData['zip'] == 1 || $recordData['zip'] == 2 || $recordData['zip'] == 3)
         $emailList123[] = $recordData;
      else if ($recordData['zip'] == 4 || $recordData['zip'] == 5 || $recordData['zip'] == 6)
         $emailList456[] = $recordData;
   }
else
   print('Could not fetch results. Query sent was: '.$sqlQuery.'<br/>'."\n");

 

This code will sort the data with desired zip codes into two arrays $emailList123 and $emailList456 in a format like:

$emailList123[fieldname]

so to access a fieldname for example, "Name" in the sixth entry you would use: $sixthName = $emailList123[5]['Name'];

[clay1]

Great thanks-- that is pretty much how I figured it could be done but arrays give me trouble

[clay1]

if ($recordData['zip'] == 1 || $recordData['zip'] == 2 || $recordData['zip'] == 3)
         $emailList123[] = $recordData;

 

For this part how could I test against an array of zips? in_array?

[dabaR]

You mean like this if(in_array($recordData['zip'], array(1, 2, 3))) { ... } ?

[clay1]

I guess so? I've got a lot of zips. Typing out record['zip'] == zip1 for every one will be a pretty lengthy file

[dabaR]

Oh, OK. Yes that is what you want then. You can read php.net/in_array if you need more examples.

[clay1]

Not sure if I should start a new topic or not but I will try here first

 

So I have the records in separate arrays as such:

 

   while ($recordData = pg_fetch_assoc($recordResults))
   {
      if (in_array($recordData['zip'], $birminghamzips)){
         $birmingham[] = $recordData;}
      elseif (in_array($recordData['zip'], $bridgewaterzips)){
         $bridgewater[] = $recordData;}

 

I have a script that creates a pdf and sends an email that I have used for a single array that I need to convert so it will send do so for each of these arrays

 

Can I put these arrays into a container array and then use another while loop?

 

something like

 

containerarray = array($zips1, zips2);
while ($containerarray){
pdfscript
email
}

[dabaR]

as in http://php.net/array_merge ?

[clay1]

(removed extraneous post)

[clay1]

as in http://php.net/array_merge ?

 

 

I mean:

 

$leadsarray = array($birmingham, $bridgewater, $coltsneck, $encino, $grandrapids, $hackensack, $houston, $irvine, $lawrenceville, $la, $nola, $palmbeach, $pittsburgh, $upland);

 

 

[dabaR]

One emailed PDF per city?

[clay1]

One emailed PDF per city?

 

Yes

 

I want to put the profiles in the proper array and then email each array to the correct email address

 

Does that make sense?

 

So birmingham profiles go to [email protected] for example

 

 

[dabaR]

Yes, that sounds kosher. Especially because I am not Jewish, and have just a vague idea what kosher is. You will be able to make an array of arrays, or two-dimensional array as geeks call it.