SV: PHP and MySql question

["Henrik Hornemann" <HEH@xxxxxxx>]

Hi,

Your problem is that your variables $Lat1,$Lat2,$Lon1,$Lon2 all reffer
to resultsets and not the Latitudes or Longitudes.
Try something like this: 

$res = mysql_query(
            "SELECT ZG_LATITUDE, ZG-LONGITUDE FROM zip_code where
zg_zipcode = '$zip'");
List($Lat,$Lon) = mysql_fetch_row($res);
$Lat1=Lat-2; $Lat2=Lat+2; $Lon1=Lon-2; $Lon2=Lat+2;

Now you can use the values in your final query. 

Hth Henrik Hornemann 

-----Oprindelig meddelelse-----
Fra: ReClMaples [mailto:reclmaples@xxxxxxxxxxxxx] 
Sendt: 16. april 2005 22:38
Til: php-db@xxxxxxxxxxxxx
Emne:  PHP and MySql question

Hello, I'm kinda new at PHP programming with MySQL.  I am having an
issue and am not sure if this is the corret way to do this:  Here is my
code, I'll start there:

<?php

  $Lat1 = mysql_query(
            "SELECT (ZG_LATITUDE-2) FROM zip_code where zg_zipcode =
'$zip'");
  if (!$Lat1) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }

$Lat2 = mysql_query(
            "SELECT (ZG_LATITUDE+2) FROM zip_code where zg_zipcode =
'$zip'");
  if (!$Lat2) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }

$Lon1 = mysql_query(
            "SELECT (ZG_LONGITUDE-2) FROM zip_code where zg_zipcode =
'$zip'");
  if (!$Lon1) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }

$Lon2 = mysql_query(
            "SELECT (ZG_LONGITUDE+2) FROM zip_code where zg_zipcode =
'$zip'");
  if (!$Lon2) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }

$ZipCode = mysql_query(
            "SELECT * FROM zip_code where ZG_LATITUDE >= '$Lat1'
and ZG_LATITUDE <= '$Lat2' and ZG_LONGITUDE >= '$Lon1' and ZG_LONGITUDE
<= '$Lon2'");
  if (!$Zipcodesearch) {
    echo("<P>Error performing query: " .
         mysql_error() . "</P>");
    exit();
  }

  while ( $row = mysql_fetch_array($ZipCode) ) {
	echo("<b>City: </b>" . $row["ZG_CITY"]. "<br>");
echo("<b>State: </b>" . $row["ZG_STATE"]. "<br>"); echo("<b>Zip Code:
</b>" . $row["ZG_ZIPCODE"]. "<br>"); echo("<b>Area Code: </b>" .
$row["ZG_AREACODE"]. "<br>"); echo("<b>County FIPS: </b>" .
$row["ZG_COUNTY_FIPS"]. "<br>"); echo("<b>County Name: </b>" .
$row["ZG_COUNTY_NAME"]. "<br>"); echo("<b>Time Zone: </b>" .
$row["ZG_TIME_ZONE"]. "<br>"); echo("<b>Day Light Savings?: </b>" .
$row["ZG_DST"]. "<br>");
echo("<b>Latitude: </b>" . $row["ZG_LATITUDE"]. "<br>");
echo("<b>Longitude: </b>" . $row["ZG_LONGITUDE"]. "<P>"); } ?>

Basically I'm trying to have a user input a zip code and then have a php
script pull all zip codes that are in a region of that submitted zip
code.
Can you have a look at my code and see what I'm doing wrong?  When using
this it returns no results but makes the connection to the database so I
have to believe that it's within here that I have my issue.

I have Apache/2.0.47 (Win32) PHP/4.3.9 Server and MySql 4.0.14 (I know I
can upgrade and be able to do subselects but I would like to know what
I'm doing wrong here.

Thanks in advance for any help.

Thanks
-rich

--
PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php