populate combo/select cell from MySQL table

Suite and Optimus Suite 5
#1

I have a grid where the cells of one column are a combo or select box. These selections should be populated from a MySQL table. Is there a way to do this? If so, is this data filterable?

Once the user makes a selection, other fields in the row will populate from the same table. (Example: column in product id, once id is selected from field [populated from MySQL table], the description, price, weight, etc are populated in the rest of the grid.

Thank you in advance.

#2

Hi

for combo u can use something like:

$sql=mysql_query("select value,label from custom_table")or die(mysql_error());
echo '<complete add="true">';
$i=0;
while(mysql_fetch_array($sql)){
	echo "<option  value='".mysql_result($sql,$i,0)."'>".mysql_result($sql,$i,1)."</option>";
$i++;
}
echo '</complete>';

which return

[code]

label_1 label_2 label_3 [/code]

XML structure: http://www.dhtmlx.com/docs/products/docsExplorer/doc/dhtmlxxml/index.html

For filtering in combo:
http://www.dhtmlx.com/docs/products/dhtmlxCombo/samples/04_filtering/

I dont think there is way how to filter in selectbox. But there is a way around. I´m using :
http://ivaynberg.github.io/select2/

For action triggered, when options is selected:
http://www.dhtmlx.com/docs/products/dhtmlxCombo/samples/05_events/01_combo_events.html

Hope it helps