I will read it slowly.

Please look at documentation.

You will need to write a aditional code for the editing of the row.

jqGrid does not do this, since it does not know which is the server type ASP, PHP or etc.

Please write this code and use the editurl variable for this purpose

http://www.trirand.com/jqgridw.....ne_editing

Regards

Hi all and sorry for my english..

I have been investigating my code and I can't understand why don't work it...

I can get the rows from my MySQL database but when I edit a row, this is edited only local. The POST doesn't include the new information and when I press reload button, old value return again.

The example is here: /blog/jqgrid/jqgrid.html Row editing using events  -->

HTML

 ...

<table id="rowed3"></table>

<div id="prowed3"></div>

<br />

<script src="rowedex3.js" type="text/javascript"> </script>

Java Scrpt code

 ...

var lastsel;

jQuery("#rowed3").jqGrid({

url:'server.php?q=2',

datatype: "json",

colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],

colModel:[

{name:'id',index:'id', width:55},

{name:'invdate',index:'invdate', width:90, editable:true},

{name:'name',index:'name', width:100,editable:true},

{name:'amount',index:'amount', width:80, align:"right",editable:true},

{name:'tax',index:'tax', width:80, align:"right",editable:true},

{name:'total',index:'total', width:80,align:"right",editable:true},

{name:'note',index:'note', width:150, sortable:false,editable:true}

],

rowNum:10,

rowList:[10,20,30],

pager: '#prowed3',

sortname: 'id',

viewrecords: true,

sortorder: "desc",

onSelectRow: function(id){

if(id && id!==lastsel){

jQuery('#rowed3').jqGrid('restoreRow',lastsel);

jQuery('#rowed3').jqGrid('editRow',id,true);

lastsel=id;

}

},

editurl: "server.php",

caption: "Using events example"

});

jQuery("#rowed3").jqGrid('navGrid',"#prowed3",{edit:false,add:false,del:false});

PHP with MySQL

...

$page = $_GET['page']; // get the requested page

$limit = $_GET['rows']; // get how many rows we want to have into the grid

$sidx = $_GET['sidx']; // get index row - i.e. user click to sort

$sord = $_GET['sord']; // get the direction

if(!$sidx) $sidx =1;

// connect to the database

$db = mysql_connect($dbhost, $dbuser, $dbpassword)

or die("Connection Error: " . mysql_error());

mysql_select_db($database) or die("Error conecting to db.");

$result = mysql_query("SELECT COUNT(*) AS count FROM invheader a, clients b WHERE a.client_id=b.client_id");

$row = mysql_fetch_array($result,MYSQL_ASSOC);

$count = $row['count'];

if( $count >0 ) {

$total_pages = ceil($count/$limit);

} else {

$total_pages = 0;

}

if ($page > $total_pages) $page=$total_pages;

$start = $limit*$page - $limit; // do not put $limit*($page - 1)

$SQL = "SELECT a.id, a.invdate, b.name, a.amount,a.tax,a.total,a.note FROM invheader a, clients b WHERE a.client_id=b.client_id ORDER BY $sidx $sord LIMIT $start , $limit";

$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());

$responce->page = $page;

$responce->total = $total_pages;

$responce->records = $count;

$i=0;

while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

$responce->rows[$i]['id']=$row[id];

$responce->rows[$i]['cell']=array($row[id],$row[invdate],$row[name],$row[amount],$row[tax],$row[total],$row[note]);

$i++;

}

echo json_encode($responce);

...