jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

How do I reconcile rowID from a grid with the TRUE rowID back in the MYSQL database??

Tags: grid rowid versus true DB row number for update/de

01/11/2011
04:47

ivanb

Member

Members

Forum Posts: 6

Member Since:
05/07/2011

Offline

Hello.

I have a the current release of JQgrid running and I have no problem searching within that grid, selecting a row, and editing it.

When I pass this upstream the PHP code shows the values for POSTed variables BUT

the ROWid posted back corresponds to the ROWid of the selected ELEMENT in the grid I edit and NOT to the

TRUE rowID of element back in the orginating table.

Consequently, I'm unsure HOW to update/delete entries based on THAT rowID.

Hows does JQgrid 'know' which row to update in the 'real table' or MUST I simply add a new column that

autoincrements and pass THAT back to use as the key for the row in the real table to update??

Don't think I need post code here... 🙂 ???

04/11/2011
23:54

ivanb

Member

Members

Forum Posts: 6

Member Since:
05/07/2011

Offline

bump 🙂 anyone have any ideas

07/11/2011
13:20

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

I think the answer is easy- you should post the TRUE Row id of the table too.

You should knowe the id not the grid.

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
29 Guest(s)

Currently Browsing this Page:
1 Guest(s)