I have a repeat group that has a dropdown element named "el5ua_bozzuto_inventory_28_repeat___po_item_status", so the element in the form has the ID "el5ua_bozzuto_inventory_28_repeat___po_item_status_0". I am using the PHP Plug-in. I use this line to grab the values from other fields in that group.
$itemstatus = $data['el5ua_bozzuto_inventory_28_repeat___po_item_status'][0];
Then I have this line in the insert SQL statement.
->set('item_status = ' . $db->quote($itemstatus))
I get this error.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'field list'
If I hard code the value everything works fine.
Can you offer any advice?
$itemstatus = $data['el5ua_bozzuto_inventory_28_repeat___po_item_status'][0];
Then I have this line in the insert SQL statement.
->set('item_status = ' . $db->quote($itemstatus))
I get this error.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'field list'
If I hard code the value everything works fine.
Can you offer any advice?