[RESOLVED] mysql Between clause

Beffic

I am kinda new to these Between clauses, never had to use one before.

Anyway, I feel like I am not approaching this quite right. I feel like the separating "AND" between posx and posy is a little too much and could be the reason the code is not displaying the way I am looking for. Any ideas/tips/guides?

$xtop = $char['posx'] + $char['foresight'];
$xbottom = $char['posx'] - $char['foresight'];
$ytop = $char['posy'] + $char['foresight'];
$ybottom = $char['posy'] - $char['foresight'];
$grabBag = mysql_query("SELECT * FROM bagdrop WHERE (`posx` BETWEEN '".$xtop."' AND '".$xbottom."') AND (`posy` BETWEEN '".$ytop."' AND '".$ybottom."')");

Weedpacket

If the values are numbers there's not much point putting them in quotes.

But aside from that, [font=monospace]columnname BETWEEN lowerbound AND upperbound[/font] is the standard syntax, equivalent to [font=monospace]columnname>=lowerbound AND columnname<=upperbound[/font].

Beffic

Would you see a problem with running two between statements in one query?

bradgrafelman

Beffic;10999693 wrote:
Would you see a problem with running two between statements in one query?

No.

The only problem I see is comparisons that don't make sense. You're using BETWEEN statements like:

posx BETWEEN 100 AND 50

where the larger number comes before the 'AND'. As Weedpacket explains, the BETWEEN syntax is nothing more than two inequalities. Rewritten using those inequalities, the above example statement becomes:

posx >= 100 AND posx <= 50

How many numbers do you know are greater than 100 and less than 50? 😉

Beffic

I guess it would help to explain what I am doing exactly.

Say you are standing in at a location of 50, 50. Well if your foresight is level 5 then you will see in a 5X5 direction around you.so seeing a "bagdrop" at 51, 46 would be accomplished.

So am I using the right reference to figure this out? Is 'between' really the best way to go about this?

Derokorian

Ah so you would do something like posx between minx and maxx and posy between miny and maxy yes? This is perfectly acceptable.

Beffic

LOL DUR DUR DUR!

I guess it would have been smarter to start with the bottom number then run it though the top number. Code works now hahaha

Thanks!