MySQL Forums
Forum List  »  PHP

Re: php query works from localhost, does not work from Windows server
Posted by: Ulf Wendel
Date: January 19, 2006 10:23AM

Ron Enderland wrote:
> You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server
> version for the right syntax to use near '-1' at
> line 1

Can you try to find our which statement is causing the problem?

> Here's the Dreamweaver MX-generated query:
>
> // begin Recordset
> $query_Recordset1 = "SELECT * FROM log";
> $Recordset1 =
> $arweb2test->SelectLimit($query_Recordset1) or
> die($arweb2test->ErrorMsg());
> $totalRows_Recordset1 =
> $Recordset1->RecordCount();
> // end Recordset

Well, that does not say too much. Can you try to find the implementation of $arweb2test->SelectLimit(...) and check which query gets executed?

Ulf

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.