[PHP-DB] MySql and PHP question

[ReClMaples]

All,

    I have a question as how I can return some results that I am looking
for.  Ideally I'd like to run this sql statement but for some reason MySql
won't allow me to run it:


SELECT
  *
FROM
  zip_code
WHERE
  zg_latitude between ((select zg_latitude from zip_code where zg_zipcode =
'78730')- 2) and
  ((select zg_latitude from zip_code where zg_zipcode = '78730') + 2)  and
  zg_longitude between ((select zg_longitude from zip_code where zg_zipcode
= '78730') - 2) and
  ((select zg_longitude from zip_code where zg_zipcode = '78730') + 2)

I get an error to check the mysql manual.  This statement runs in an oracle
environment though.

I guess I am stuck with writing multiple queries and them tying them
together.  In PHP how can I put a variable into the sql statement (if that's
possible).  Let's say I have these queries:
select zg_longitude from zip_code where zg_zipcode = '78730'

This one pulls the zg_longitude from the zip_code table where the zip_code
is 78730 for instance.  I want to take the result (one record) and put it in
this sql statment replacing 'result here':

select * from zip_code
where zg_longitude >= ('result here'-2)
and zg_longitude <= ('result here'+2)
order by zg_city asc

Can anyone help me with this or point me in a better direction?

Thanks

-Rich