I am developing this form module to delete only fid and uid from mydata table in the database but i cont get it to work. Please help....
<?php
function mydata_page_form($form, $form_state){
$form = array();
$header = array( t('File ID'), t('File Name'), t('File link'), t('User'),
);
$query = db_select('mydata', 'm')->extend('PagerDefault') ;
$query->join('file_managed', 'f', 'f.fid = m.fid ');
$query->addjoin('INNER','users', 'u', 'm.uid = u.uid ');
$query
->fields ('m', array('fid', 'uid'))
->fields ('f', array('filename', 'uri'))
->fields ('u', array('name'))
->orderBy ('fid','DESC')
->limit(15);
$results = $query -> execute();
$rows = array();
foreach($results as $result){
$rows[] = array (
$result->fid,
$result->filename,
$result->uri,
$result->name,
);
}
$form['mydata_table'] = array(
'#type' => 'tableselect',
'#header' => $header,
'#options' => $rows,
'#empty' => t('no application found'),
);
$form['pager'] = array ('#markup' => theme('pager'));
//$form['mydata_delete']['deletemydata'] = array(
// '#type' => 'checkbox',
// '#title' => 'Delete',
// '#return_value' => 1,
// '#default_value' => 0,
// '#descrption' => t("If the box check, the list checked in the table will be remove")
//);
$form['delete'] = array(
'#type' => 'submit',
'#value' => t('delete'),
'#submit' => array('mydata_page_form_delete'),
);
return $form;
}
function mydata_page_form_delete($form, $form_state){
//dsm($form_state);
$selected = array_filter($form_state['values']['mydata_table']);
db_delete('mydata')
->condition('fid', $selected,'IN' )
->execute();
}