jQuery Grid Plugin - jqGrid

Ok, JSON or XML, it doesn't really make a difference, there doesn't appear to be any example showing how to populate the drop down select box with dynamic data.

That is, not to have the simple data listed in the grid options.

What I have is simple, a list of products, suppliers and product categories.  Suppliers and Product Categories are simple lists from the database, Products include supplier id and category id, but display in the grid with product name, supplier name and category name.

What I need is a dropdown which will include the supplier id and name, which will be selectable when doing a form edit.

But I find no examle of how to properly create that select dropdown, and populate it with proper values.

I need your help, and a simple tutorial on how to do this properly.  unfortunately I cannot find one.

Ray

Yes, I read the entire documentation, and looked at that particular info for the new improvements, however,it states simply:

editoptions:{dataUrl:'test.txt', defaultValue:'Intime'},

Which does nto really tell the format of the info in test.txt, if it's in json or not, although another website does specify to enter the information in semicolon separated data:

{"Countries":{"Content":"230:UNITED STATES;40:CANADA;7:AFGHANISTAN;
etc.....   }}


However, it does not specify it this is to be json encoded (which I assume, but does not work)  

So, to refresh, format for the test.txt file is not specified, if it is I cannot find it.  I believe this should be correct, 
but is not working correctly for me.

    foreach ($query->result() as $row)
      {
      $response->rows[$i]['id'] = $row->id;
      $response->rows[$i]['cell'] = array($row->id,$row->supplier_name);
      $i++;
      }
    echo json_encode($response);

Is this correct and simply an error in my part, or is the encoding for the dropdown (test.txt) not json?

Thanks,
Ray

Hello Tony,

Sorry, i must have missed that, saw most everything else, except for that item.

So, not json formatted, but standard html select element.  I will try and advise if there are any issues.

Thank you,

Ray