Bizarre issue:

Running an in-house intranet. I can run a MySQl query from my Linux server to a locally-hosted database no problem. RHEL 4.1, mysql 4.1.12-3. However, when I run a query from my Windows-based secured access machine, I get the old "You have an error in your SQL syntax" message.

This happens on any query. I have turned iptables off on the Linux box, no help. I have confirmed that mysqld is running. I can connect through Dreamweaver and test the connection, no problem. I can also connect to locally-hosted MySQL databases on the Windows box, too.

This issue occurs both in Firefox 1.5 and IE6.

Here's the code:

$query_Recordset1 = "SELECT * FROM log";
$Recordset1 = $arweb2test->SelectLimit($query_Recordset1) or die($arweb2test->ErrorMsg());
$totalRows_Recordset1 = $Recordset1->RecordCount();