What is wrong with this sql query

[fraser5002]

Hi,

 

Can anyone let me know what is wrong with this SQL query i am getting an error saying my argument is not valid

 

//
//
$query_accommodation="SELECT * FROM accommodation WHERE lat > '(base_lat - 0.2)' AND lat < '(base_lat +0.2)' AND long > '(base_lon - 0.2)' AND long < '(base_lon+0.2)'";
//
//

 

base_lon and base_lat have already been predefiend

 

e.g

$base_lon = xxx;

$base_lat = xxx;

 

Im basically trying to query my accomodation database and find all accomodation near to a base location

 

cheers

[Matthias_]

$query_accommodation="SELECT * FROM accommodation WHERE lat > '($base_lat - 0.2)' AND lat < '($base_lat +0.2)' AND long > '($base_lon - 0.2)' AND long < '($base_lon+0.2)'";

 

That should work.

[ignace]

It should be:

 

SELECT * FROM accommodation WHERE lat > (base_lat - 0.2) AND lat < (base_lat +0.2) AND long > (base_lon - 0.2) AND long < (base_lon+0.2)

 

Enclosing it between quotes made it convert from string to integer which would result in:

 

lat > base_lat AND lat < base_lat AND long > base_lon AND long < base_lon

[madmax3]

Check this:

 

$query_accommodation="SELECT * FROM accommodation WHERE lat > '($base_lat - 0.2)' AND lat < '($base_lat +0.2)' AND long > '($base_lon - 0.2)' AND long < '($base_lon+0.2)'";

[fraser5002]

Hi All thanks for the replies

it seems to be a problem with the longitude part of the query as this is still not working

 

is it because the longitudes are negative numbers?

 

 

This works

 

$query_accommodation="SELECT * FROM accommodation WHERE lat > ($hill_lat - 0.2) AND lat < ($hill_lat +0.2)")

 

 

this does not work

 

$query_accommodation="SELECT * FROM accommodation WHERE lat > ($hill_lat - 0.2) AND lat < ($hill_lat +0.2) AND long > ($hill_lon - 0.2))";

 

like i said the longitude values in question is negative but why should this make a difference?

[fenway]

Echo the ACTUAL query you're sending to the server -- and you'll see.

[fraser5002]

i have done this

 

$hill_lon = -5.00352

long in database = -5.1069

 

 

 

long field in database is stored as a float

 

i dont really understand why this should throw the error

[fenway]

Like I said... echo the full query.