query works with "Test" button, but not when placed on page

Hello,

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:
<?php
$rsMonth1SatsTitle = new WA_MySQLi_RS("rsMonth1SatsTitle",$mysqli_workshops,1);
$rsMonth1SatsTitle->setQuery("SELECT (DATE_ADD(CURDATE(), INTERVAL 0 MONTH));");
$rsMonth1SatsTitle->execute();
?>

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,
Thank you,
KAB

Just to clarify,
I have found a workaround.
So you can put this one on the back burner, because I doubt anyone will really need it

Thank you.
KAB

Hello,
The listing of Posts/Views/Replies at the side on the right in the preceding "View" indicates that you made a response to this.
I do not see any such post here. (And also did not receive an email).

(Just in case you did respond, and/or there's something amiss in the backend).
Thank you,
KAB

No, I just marked it as viewed so I know that it doesn't need a response. Whenever someone does a post it stays marked as needing a response unless I update and mark it as not needing one. It is just me managing my queue.