rob-t on "Could not update" error when updating info in database

Fri, 07 Jan 2011 22:55:59 +0200

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';

jQuery Grid Plugin - jqGrid - Topic: "Could not update" error when updating info in database

rob-t on "Could not update" error when updating info in database