dhtmlxgrid- PHP-MySql- tables with a large number of columns

I have the pro version of dhtmlxgrid and have been developing applications using PHP and mySql.



I have been using the standard PHP scriopts that come with the Pro version for interfacing with MySql.



With a MySql table with a few rows ( say 6) the scripts are working perfectly. However, when I try and run the scripts tied to a MySql table with 25 columns the scripts are not working correctly. The data in the table is displayed on the grid correctly but the scripts to create a new row or update an existibng row in the database do not update the database.



I have checked and rechecked but cannot see what the problem is.



Has anyone else experienced this problem?



Any guidance would be appreciated.



regards



Angus


Most probably you have
a field with name or type which require special kind of escaping while using in
SQL queries. ( the name of fields used only in update|insert queries which are
not works for you )<o:p></o:p>




If problem still occurs
for you � please send problematic table schema.<o:p></o:p>




<o:p> </o:p>



While common code
provided with dataProcessor lib can be used as fast solution, you always can
create a custom one, which will work exactly for your situation, please check
attached sample which can be used instead of common server side script
<o:p></o:p>



update.php.zip (998 Bytes)