PDA

View Full Version : mysql use of AND statement question


lolzownz
12-23-2006, 08:07 AM
I'm using Diablo like loot maker ver 1.3.2 from http://66.159.225.58/eqemu/eq.html and I

RangerDown
12-23-2006, 01:00 PM
Check to see if it's a known bug for the version of mysql you're using. (mysql forums or googling might get you that answer) I have been witness to a bug in mysql's logic once before so it's not totally out of the question that this is just a bug too.

GeorgeS
12-24-2006, 07:06 AM
I looked at this in more detail - using AND's and OR's...

I added brackets when using OR's so they take precedence over AND's. I added this to the recent code and it's available for download now.

Thanks for pointing this out.

btw - when using sql using or's and and's use
(a=1 OR a=2) AND b=3 AND b=4

GeorgeS