tripal/base/tripal_views_setup/includes/tripal_views_setup.admin.inc

<?php 

function tripal_views_setup_admin_form(){
	
	$form = array();
	
	$form['#theme'] = 'tripal';
	
	$query_results = db_query('SELECT * FROM public.tripal_views_setup;');
	
	$header = array('Setup ID', 'Name', 'Materialized View ID', 'Base Table Name', 'Description');
	$rows = array();
	
	$results = array();
	while($result = db_fetch_object($query_results)){
		$rows[] = array($result->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' => '<strong>Select a View Setup to delete from the database.</strong>',
		'#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;");
}