diff options
| -rwxr-xr-x | textbook_companion.module | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/textbook_companion.module b/textbook_companion.module index 87c6321..b9e1305 100755 --- a/textbook_companion.module +++ b/textbook_companion.module @@ -1451,6 +1451,7 @@ function book_proposal_form($form, &$form_state) '#type' => 'select', '#title' => t('Select the category'), '#options' => _tbc_list_of_main_categories(), + '#default_value' => 0, '#required' => TRUE ); $form['samplefile'] = array( @@ -1710,7 +1711,7 @@ function book_proposal_form_submit($form, &$form_state, $directory_name = NULL) $pref_id = NULL; $directory_name = _dir_name($bk1, $auth1, $pref_id); $query = "INSERT INTO {textbook_companion_preference} - (proposal_id, pref_number, book, author, isbn, publisher, edition, year, category, subcategory, approval_status, directory_name) VALUES (:proposal_id, :pref_number, :book, :author, :isbn, :publisher, :edition, :year, :category, :subcategory, :approval_status, :directory_name) + (proposal_id, pref_number, book, author, isbn, publisher, edition, year, category, approval_status, directory_name) VALUES (:proposal_id, :pref_number, :book, :author, :isbn, :publisher, :edition, :year, :category, :approval_status, :directory_name) "; $args = array( ":proposal_id" => $proposal_id, @@ -1722,7 +1723,6 @@ function book_proposal_form_submit($form, &$form_state, $directory_name = NULL) ":edition" => trim($form_state['values']['edition1']), ":year" => trim($form_state['values']['year1']), ":category" => $form_state['values']['category'], - ':subcategory' => 0, ":approval_status" => 0, ":directory_name" => $form_state['values']['dir_name1'] ); @@ -3583,13 +3583,13 @@ function _tbc_list_of_main_categories() 0 => 'Please select ...' ); //$maincategory = array(); - $query = db_select('tbc_maincategory'); - $query->fields('tbc_maincategory'); - $query->orderBy('id', 'ASC'); + $query = db_select('list_of_category'); + $query->fields(' list_of_category'); + $query->orderBy('category_id', 'ASC'); $maincategory_list = $query->execute(); while ($maincategory_list_data = $maincategory_list->fetchObject()) { - $maincategory[$maincategory_list_data->id] = $maincategory_list_data->maincategory_name; + $maincategory[$maincategory_list_data->category_id] = $maincategory_list_data->maincategory; } //$software_version_list_data = $software_version_list->fetchObject() return $maincategory; } |