jQuery Grid Plugin - jqGridForum

Topic RSS

"Could not update" error when updating info in database

07/01/2011
22:55

rob-t

Member

Members

Forum Posts: 3

Member Since:
07/01/2011

Offline

Hi there. Thanks for jqgrid, it's great! I am very new at php, sql, and java, so please bear with me.

I am using jqGrid for PHP v3.8 (http://www.trirand.net/download.aspx).

UPDATE: I got it working, at least for one table. My problem was that I never defined a key in my grid.php.

I had to add this info (based on the demos):

// Set the table to where you add the data
$grid->table = 'customers';
$grid->setPrimaryKeyId('CustomerID');
$grid->serialKey = false;

// The primary key should be entered
$grid->setColProperty('CustomerID', array("editrules"=>array("required"=>true)));

So does anyone know how I can set this up to pull data from more than one database table and then save it to the appropriate table so that it can all be edited on one grid?

For example, my select command uses data from 3 tables:

$grid->SelectCommand = 'SELECT a.uid, a.name, b.firm, b.city, b.state, a.mail, b.paidmembershipdate, b.firmcategoryone FROM users a, profile b, node c WHERE a.uid=c.uid AND c.nid=b.nid';

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
61 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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66