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
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.