[RESOLVED] zipcode

slimjim

How can I do this :
Currently it looks for any zipcode that is less then and greater then..
I want it to search for any zipcode that is less then, greater then and equal too
$zip

      $sql = "SELECT zip_code, lattitude, longitude FROM zip_code
              WHERE zip_code <> $zip";

Houdini

Something kind of like

$sql = "SELECT zip_code, lattitude, longitude FROM zip_code
              WHERE zip_code BETWEEN '$zip' AND '$zip2'";

slimjim

Here is the function..
Currently it looks for zip within a certain range, but does not give any results with the zipcode $zip.

Example: it finds 12 zipcodes within a 12 mile range of 12345 but it doesnt show in the results the zipcode $zip 12345
It only is showing the others...

   function get_zips_in_range($zip, $range) {

  // returns an array of the zip codes within $range of $zip. Returns
  // an array with keys as zip codes and values as the distance from 
  // the zipcode defined in $zip.

  $this->chronometer();                     // start the clock

  $details = $this->get_zip_point($zip);  // base zip details
  if (empty($details)) return;

  $return = array();    // declared here for scope
  //I think the $sql statement belows is wrong, I think it needs something like <> and = :)
  $sql = "SELECT zip_code, lattitude, longitude FROM zip_code
          WHERE zip_code <> $zip";
  $r = mysql_query($sql);

  if (!$r) {    // sql error

     $this->last_error = mysql_error();
     return;

  } else {

     while ($row = mysql_fetch_row($r)) {

        // loop through all 40 some thousand zip codes and determine whether
        // or not it's within the specified range.

        $dist = $this->calculate_mileage($details[0],$row[1],$details[1],$row[2]);
        if ($this->units == 'k') $dist = $dist * 1.609344;
        if ($dist <= $range) {
           $return[str_pad($row[0], 5, "0", STR_PAD_LEFT)] = round($dist, $this->decimals);
        }
     }
     mysql_free_result($r);
  }

  $this->last_time = $this->chronometer();

  return $return;
   }

slimjim

		$zipcode=$myrow["zipcode"];
	}
//The below used to be $zip = $z->get_zips_in_range("$zip", 12);
//But as you can see it gets the zipcode now called $zipcode

$zips = $z->get_zips_in_range("$zipcode", 12);
if (empty($zips)) echo 'Error: '.$z->last_error;
   foreach ($zips as $key => $value)
    {

Or maybe there is a way to change the foreach somehow so that $key also includes $zipcode

ClarkF1

Can't you add "OR zipcode = $zip" to the query

slimjim

Please anyone have a clue on this ?

ClarkF1

Did you try my suggestion???

slimjim

Yeah that didnt work...
Going crazy over this....

slimjim

      $sql = "SELECT zip_code, lattitude, longitude FROM zip_code
              WHERE zip_code <> $zip OR zip_code = $zip";

Added it like this...

dcav

If it's less than, greater than and equal to, then you don't even need the WHERE condition.

All your records should match your criteria.

Houdini

dcav wrote:
If it's less than, greater than and equal to, then you don't even need the WHERE condition.

All your records should match your criteria.

Great logic, as long as it is a zip code it qualifies (it probably also qualifies even if it is not valid like 47ab9

slimjim

OK well this one works, of course if a person puts in something other then a zipcode, it would be dumb

      $sql = "SELECT zip_code, lattitude, longitude FROM zip_code
              WHERE zip_code <> $zip OR zip_code LIKE'$zip'";

dcav

I do not understand why you put the WHERE condition in your context.

In your latest query, you are basically asking if the $zip is not equal to OR equal to the records of your table.

That would mean every record. Even if that person inputs anything dumb, all records from your table zip_code will still be returned.

To verify the integrity of user inputs, you can, at minimum, verify the length of the zip code(5, if in US). If you want to go deeper in the validation process, you can use regex.

$sql = "SELECT * FROM zip_code";

$sql = "SELECT zip_code, lattitude, longitude FROM zip_code"; // OR, if your function takes in the parameters in this sequence..

That is sufficient.

Based on your problem, that is what you probably want to do anyway. Since you are determining if the user input zip code is within the range radius only per record fetching.