Issue with negative number and a query

pedroteixeira07

Hello,
I'm running through an issue that I'm seeing the fastest solution.

I have this query to my DB:

	$query1="SELECT Position_ID, GPSLatitude, GPSLongitude FROM Position WHERE GPSLatitude BETWEEN $bottomlatitude AND $toplatitude AND GPSLongitude BETWEEN $leftlongitude AND $rightlongitude ORDER BY `Position`.`GPSLatitude` ASC LIMIT $i,1";

The problem is this variables: $bottomlatitude, $toplatitude, $leftlongitude, $rightlongitude might have negative values depending on the position.

When they are all positive it will be ok, but if their negative the BETWEEN statement doesnt make any sense. Does anyone has a solution for this? Is there any SQL command to deal with this? I can't make an abs because I need the result to be stored as it really is, and also to be queried to the database as it really is.

Thank you very much

dagon

but if their negative the BETWEEN statement doesn't make any sense

don't under stand that as 0 is between 1 and -1

pedroteixeira07

Having for example a longitude value of -15

When I run this query with the values:
rightlongitude=-17
leftlongitude=0

it doesnt get me any results.. I need the query to be generic that

BETWEEN rightlongitude AND leftlongitude

BETWEEN leftlongitude AND rightlongitude

works regardless of the negative values or not

bradgrafelman

You need to re-arrange the data. The BETWEEN statement only cares about minimum and maximum values, so that's what you have to think in terms of.

You can either do the processing in PHP to make sure the values get placed in the right location, or you could use MySQL's GREATEST() and LEAST() functions.