marc_r

I have the following query: [b]"SELECT * FROM products WHERE MATCH(Product_No, Title, Category) AGAINST ('$keyword*' in boolean mode)";[/b] and gives me this error: [b]#1064 - You have an error in your SQL syntax near 'boolean mode )[/b] The query was working fine on my local server but once i migrated it to the new remote server it wont let me run this. I've also tried the query w/o 'in boolean mode' and it works just fine.. anyone have any ideas please?? thanks! marc

I built a site on my local server on which i was running PHP 5.0.4 and recently the company I'm working for got a new server. A lot of my code wasn't running the way it was supposed to on this new server and i couldn't figure out why..and i just found out that they're running 4.4.0..could this have a huge impact? should i ask them to update or is there more behind this problem? thanks

I'm having the same exact problem. Ive been using the same code for other sites and the code worked perfectly on my local server and on another one, however as soon as I uploaded it this new server the code stopped working and I got these same error messages.