Forum
Log In
Home
Topic RSS
Related Topics
13:50
31/05/2011
Offline
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 >
16:07
25/02/2009
Offline
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 (...
02:17
31/05/2011
Offline
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);
Most Users Ever Online: 715
Currently Online:
48 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
