Datatable editable

Maddy

Hi, I have a PHP-MySQL application which uses datatable. The datatable gets populated using select query from mysql table. I want to make the rows editable now in a way that when i double click on the row, a form should be opened and should allow me to edit the cells. When I click ok button, the data should be updated in mysql tables. Is this possible to achieve. Can someone please guide me??

Currently, this is how my datatable looks - (datatablecolumns is defined in previous statement)
$('#dataTableProjects').dataTable({
"aaSorting": [ [0,'asc'] ],
"aoColumns" : dataTableColumns,
"oLanguage": {
"sLengthMenu": 'Show '+
'10<\/option>'+
'25<\/option>'+
'50<\/option>'+
'100<\/option>'+
'All<\/option>'+
'<\/select> records'
},
"iDisplayLength": -1,
});
});

Thanks!!

Maddy

Please help!!