setup_id, $result->name, $result->mview_id, $result->base_table_name, $result->description,); $results[] = $result; } $options = array(); foreach ($results as $key => $value) { if(!empty($value)) $options[] = $value->setup_id;// . ' | ' . $value->name . ' | ' . $value->mview_id . ' | ' . $value->base_table_name; } $form['existing_rows'] = array( '#type' => 'select', '#options' => $options, '#description' => 'Select a View Setup to delete from the database.', '#prefix' => theme('table', $header, $rows), ); $form['submit'] = array( '#type' => 'submit', '#value' => t('Remove'), ); $form['cancel'] = array( '#type' => 'markup', '#value' => l(t('Cancel '), 'admin/tripal/'), ); $form['new'] = array( '#type' => 'markup', '#value' => l(t(' New'), 'admin/tripal/tripal_views_setup_new'), ); return $form; } function tripal_views_setup_admin_form_submit($form, &$form_state){ $value = $form['existing_rows']['#options'][$form_state['values']['existing_rows']]; db_query("DELETE FROM public.tripal_views_setup WHERE setup_id = $value;"); }