jQuery Grid Plugin - jqGrid - Topic: How to add primary Key Other Than id

bappyiub on How to add primary Key Other Than id

Wed, 01 Jun 2011 02:17:33 +0300

Can you explain a bit ? My code is where to add primary key?

$SQL = "SELECT * FROM jqrgrid_option_tb";
$result = mysql_query( $SQL ) or die("Couldn't execute query.".mysql_error());
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$responces->rows[$i]['fid']=PrimaryKey;

$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$responce->rows[$i]=$row;
$i++;
}
$json = new Services_JSON();
echo $json->encode($responce);

cvneo on How to add primary Key Other Than id

Tue, 31 May 2011 16:07:39 +0300

Hello,
must set the primary key id in the PHP code that sends data to jqgrid:

$ responces-> rows [$ i] ['id'] = PrimaryKey
$ responces-> rows [$ i] ['cell'] = array (...

bappyiub on How to add primary Key Other Than id

Tue, 31 May 2011 13:50:28 +0300

JqGrid take id as default primary key.How to add primary key other than id.

In my table I have id ,which is not not a primary key. And fid which is a primary key.How to make fid as primay key instead of id >