How to use associative array in WHERE clause

[Karl Engstrom]

(I started this under an improper title, will request bounce of the other)
Hello All-
I'm new to php. I'm working on using a zip code class I found in order to create a locater app using 2 tables in a db, one is US zip codes with lat & log info and the other table is company info with a zip code field.
The output I'm working with is an associative array with zip codes and the distance from the originating zip code they are. I have this code grabbing the array contents and showing me what's there
[php]$z = new zipcode_class;
$zips = $z->get_zips_in_range($_POST["zip1"], $_POST["radius"], _ZIPS_SORT_BY_DISTANCE_ASC, true);
if ($zips === false) echo 'Error: '.$z->last_error;

else {foreach ($zips as $zcodes => $dist)
print_r ($zips);
[/php]
(get_zips_in_range is a function and _ZIPS_SORT_BY_DISTANCE_ASC is a switch, both from the class)

Example array contents is
Array ( [92629] => 0 [92624] => 2.14 [92693] => 2.41 [92677] => 2.86 [92675] => 3.3 [92673] => 3.51 [92607] => 3.75 [92674] => 4.9 [92672] => 4.96 ).

I'm hoping to use zcodes as a where clause on the company info table.Echoing zcodes shows a continuous string like
926299262492693926779267592673926079267492672
which I obviously can't use in the clause.

Any help would be great! I'm feeling sooo lost!!

Thanks,
Karl

[ronverdonk]

I'm hoping to use zcodes as a where clause on the company info table.Echoing zcodes shows a continuous string like
926299262492693926779267592673926079267492672
which I obviously can't use in the clause.

Hold a second! From your code I understand that the zcodes are the keys of the array, right? So you can use them individually in your WHERE clause.

Are you, by the way, echoing the zcodes without breaks, so forcing a continuous string? Or am I completely off?

Ronald :cool:

[Karl Engstrom]

Hold a second! From your code I understand that the zcodes are the keys of the array, right? So you can use them individually in your WHERE clause.

Are you, by the way, echoing the zcodes without breaks, so forcing a continuous string? Or am I completely off?

Ronald :cool:

Hi Ronald-

my echo is just

echo $zcodes;

for checking the oputput.

Here's what I'm working with as of now:

{
 $z = new zipcode_class;
 $zips = $z->get_zips_in_range($_POST["zip1"], $_POST["radius"], _ZIPS_SORT_BY_DISTANCE_ASC, true);
 if ($zips === false) echo 'Error: '.$z->last_error;
 else {
     $vzips=0;
     foreach ($zips as $zcodes => $dist)
         {
         if ($vzips++) {$zcodes .= ',' . $azcodes;}
         else {$zcodes = $azcodes;}
         }
     echo $zcodes;
 
     //$query_rsTech = sprintf("SELECT * FROM tech_info WHERE tech_zip_code IN (%s)", mysql_real_escape_string($zcodes));
     $query_rsTech = "SELECT * FROM tech_info WHERE tech_zip_code IN (92629,92624,92693,92677,92675,92673,92607,92674,92672)";
     $rsTech = mysql_query($query_rsTech) or die(mysql_error());
     $row_rsTech = mysql_fetch_assoc($rsTech);
     }
 }
 
 

(The class is by Micah Carrick)

The uncommented query is an example of what I'm working towards...
Am I way lost?still not getting the string I need

Thanks
Karl

[ronverdonk]

[php]
{
$z = new zipcode_class;
$zips = $z->get_zips_in_range($_POST["zip1"], $_POST["radius"], _ZIPS_SORT_BY_DISTANCE_ASC, true);
if ($zips === false) echo 'Error: '.$z->last_error;
else {
$vzips=0;
foreach ($zips as $zcodes => $dist)
{
if ($vzips++) {$zcodes .= ',' . $azcodes;}
else {$zcodes = $azcodes;}
}
echo $zcodes;

//$query_rsTech = sprintf("SELECT * FROM tech_info WHERE tech_zip_code IN (%s)", mysql_real_escape_string($zcodes));
$query_rsTech = "SELECT * FROM tech_info WHERE tech_zip_code IN (92629,92624,92693,92677,92675,92673,92607,92674,9 2672)";
$rsTech = mysql_query($query_rsTech) or die(mysql_error());
$row_rsTech = mysql_fetch_assoc($rsTech);
}
}
[/php]

That code cannot work! Statement "foreach ($zips as $zcodes => $dist)" assigns $zcodes as the key. Next statement "$zcodes .= ',' . $azcodes;}" overwrites it. In my opinion the code should be:

[php]
{
$z = new zipcode_class;
$zips = $z->get_zips_in_range($_POST["zip1"], $_POST["radius"], _ZIPS_SORT_BY_DISTANCE_ASC, true);
if ($zips === false) echo 'Error: '.$z->last_error;
else {
$vzips=0;
foreach ($zips as $zcodes => $dist)
{
if ($vzips++) {$qzcodes .= ',' . $zcodes;}
else {$qzcodes = $zcodes;}
}
echo $qzcodes;

$query_rsTech = sprintf("SELECT * FROM tech_info WHERE tech_zip_code IN (%s)", mysql_real_escape_string($qzcodes));
//$query_rsTech = "SELECT * FROM tech_info WHERE tech_zip_code IN (92629,92624,92693,92677,92675,92673,92607,92674,9 2672)";
$rsTech = mysql_query($query_rsTech) or die(mysql_error());
$row_rsTech = mysql_fetch_assoc($rsTech);
}
}
[/php]

Test that and see what the echo returns. Should be an array starting with a comma en values separated by comm's.

Ronald :cool:

[Karl Engstrom]

Thanks Ronald, you nailed it!

Not more than an hour ago I saw the err of my ways (with help from a buddy). Our code looks just like yours with slightly different var names. Now I'm on to the next phase...

I'm learning all the time & really enjoying PHP!

MegaThanks for your help!
Karl

[ronverdonk]

You are welcome.

But, if you have received this code from someone and tried to use it as-is, the giver cheated because it can never work!

See you again.

Ronald :cool:

[cassbiz]

Hi Karl,

It is funny, your name is the same as one of my college professors who was in San Diego, CA 20+ years ago.