NYCPHP Meetup

[Rob Marscher]

Sorry... I looked at it a little too quickly...  You need to put your if 
statement outside the foreach.  That was the issue.

$zips = $z->get_zips_in_range('07732', '10', _ZIPS_SORT_BY_DISTANCE_ASC, true);
if(isset($zips) && count($key) > 0)
//find all locations within range using returned zipcode values
{
  foreach ($zips as $key => $value)
  {
    $sql_events = mysql_query("SELECT * FROM area36 WHERE zipcode  
    ='$key'") or die (mysql_error());
    while ($row = mysql_fetch_array($sql_events)) {
      // process rows
    }
  }
}
// error statement if no locations are found within search radius
else {
  echo 'Sorry, your search returned no locations.  Try using a larger  
  radius to search.';
}



Paul wrote:
> If I do as I think you suggested here:
> On Nov 16, 2006, at 11:35 AM, Rob Marscher wrote:
>
>   
>> You want to use mysql_num_rows -
>> http://us3.php.net/manual/en/function.mysql-num-rows.php - after your
>> query.  You can then do an if statement to check if mysql_num_rows ! 
>> = 0
>> before doing the while loop:
>>
>> $sql_events = mysql_query("SELECT * FROM area36 WHERE zipcode
>> ='$key'") or die (mysql_error());
>> if (mysql_num_rows() !== 0)
>> {
>>   while ($row = mysql_fetch_array($sql_events)) {
>>     // stuff in here
>>   }
>> }
>> else
>> {
>>   // error - no records found
>> }
>>     
>
>
> My  correction snippet based on that here:
>
> {
> $sql_events = mysql_query("SELECT * FROM area36 WHERE zipcode  
> ='$key'") or die (mysql_error());
> if (mysql_num_rows($sql_events) !== 0)
> {
> while ($row = mysql_fetch_array($sql_events)) {
> 	$dist = $row['dist'];
>      $day = $row['day'];
>      $town = $row['town'];
> 	$time = $row['time'];
> 	$place = $row['place'];
> 	$street = $row['street'];
> 	$type = $row['type'];
> 	$Special = $row['Special'];
> 	$hca = $row['hca'];
> 	$ns = $row['ns'];
>
>      //row count for alternating colors
>
>      $row_color = ($row_count % 2) ? $color1 : $color2;
>
>      //create tables for data row loop
>
>      echo "<tr>
> 	<td class='$row_color'>$dist</td>
>      <td class='$row_color'>$day</td>
>      <td class='$row_color'>$town</a></td>
> 	<td class='$row_color'>$time</a></td>
> 	<td class='$row_color'>$place</a></td>
> 	<td class='$row_color'>$street</a></td>
> 	<td class='$row_color'>$type</a></td>
> 	<td class='$row_color'>$Special</a></td>
> 	<td class='$row_color'>$hca</a></td>
> 	<td class='$row_color'>$ns</a></td>
>      </tr>";
>
>      // Add 1 to the row count
>
>      $row_count++;
> }
> }
> // error statement if no locations are found within search radius
> else {
> echo 'Sorry, your search returned no locations.  Try using a larger  
> radius to search.';
> }
>
>
>
> Returns the error statement each time there is an x amount positive  
> result.  This was the exact problem I was having.  So what I get is  
> the error repeated x amount of  times than my table is built with the  
> actual results.  What am I missing?
>
> Paul Guba
>
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
>   

-- 
Rob Marscher
Software Engineer
rmarscher at beaffinitive.com
212.684.9100x17