query works with "Test" button, but not when placed on page
When I run the following query in Navicat, it works:
SELECT (DATE_ADD(CURDATE(), INTERVAL 0 MONTH));
It also works when I open the MySQLi recordset dialogue box, hit the Advanced button, insert that query into the dialogue box, and hit the "Test" button. It gives me the same response.
And when I hit OK, the query gets inserted onto the page just fine as follows:
$rsMonth1SatsTitle = new WA_MySQLi_RS("rsMonth1SatsTitle",$mysqli_workshops,1);
$rsMonth1SatsTitle->setQuery("SELECT (DATE_ADD(CURDATE(), INTERVAL 0 MONTH));");
But when I upload the page--with that inserted text--onto the server and run it there by loading the page, I get the message:
"There is an error in your SQL syntax".
When I delete the MySQLi query text, the page works again.
I am therefore at a loss,