DW CS4 with PHP/MySQL

I have been experiencing a similar problem. When I open a recordset from the Bindings panel and attempt to addURL parameters and then save the recordset, the resulting code added to the MySQL is both syntactically and logically incorrect. The code that checks for the presence of a passed parameter (ISET function) has the wrong bracket syntax,and as you pointed out, an entirely invalid TOTALROWS statement is inserted in the wrong place in the SQL statement.Furthermore, I find that the Adobe documentation on the use and manipulation of URL parameters via the CS4 interface is woefully lacking. I'm basically reduced to hard-coding the logic at this point.

Message was edited by: Timbo9799

kal-hadi wrote: Anytime I would filter a recordset  using "URL Parameter" ,Dreamweaver would totaly mess up the recorset. When I go to "Advanced" I see that there is an additional SQL Variable named "totalRows" in addition to another one named "colname". Everytime I cleaned up the SQL statement only to revert it back.

I just done some testing with a PHP/MySQL recordset, opening and closing the Recordset dialog box in both Simple and Advanced mode several times. I cannot reproduce the problem you report.

If u wanna use URL Parameter, make sure u are using the correct passing parameter