hi gxjenkins
The V3 beta does indeed include my fix for the search box.. but your sql shows there's still a bug... this part of code (excuses!) is moku's original design, so I need to look at it with intensity to see what it's supposed to do
There is obviously a small fault in the code (in the 'if' section on line 32 onwards in file class.productBookSearch.php..) where an 'AND' gets added into the construction of the query.
I will pm you now, asking for some more easy to get info.
Incidentally, to 'private message' someone just click on the user's name in top left of the post, it should give the option to p.m that person. Myself I prefer not to see the longer sql's in the thread, because unless one is a sql genius (which I'm not) reading sql is not fun..
Bookmarks