Displaying the correct page after inserting a "Music Genre" extra

At the moment, the Admin->Extras->Music Genre displays up to 20 rows per page.

Currently, whenever I insert a Music Genre (when there are more than 20 entries), and click "Save", it will then go to show Page 1.

How can I modify this behaviour so that it displays the page where the new entry has been inserted?

For example, let's say I already have 50 entries in Music Genre so it will be split into 3 pages. I then insert a new Music Genre that alphabetically slots in at listing number 38 but has the mID of 51.

Current behaviour after I add the new Music Genre is to display Page 1. How can I change it to display page 2 so that mID 51 can be highlighted at listing number 38 automatically after clicking on "Save"?

You could try this by adding the code in RED:

  $music_genre_query_raw = "select * from " . TABLE_MUSIC_GENRE . " order by music_genre_name";

// Split Page
// reset page when page is unknown
if (($_GET['page'] == '' or $_GET['page'] == '1') and $_GET['mID'] != '') {
  $check_page = $db->Execute($music_genre_query_raw);
  $check_count=1;
  if ($check_page->RecordCount() > MAX_DISPLAY_SEARCH_RESULTS) {
    while (!$check_page->EOF) {
      if ($check_page->fields['music_genre_id'] == $_GET['mID']) {
        break;
      }
      $check_count++;
      $check_page->MoveNext();
    }
    $_GET['page'] = round((($check_count/MAX_DISPLAY_SEARCH_RESULTS)+(fmod_round($check_count,MAX_DISPLAY_SEARCH_RESULTS) !=0 ? .5 : 0)),0);
  } else {
    $_GET['page'] = 1;
  }
}

  $music_genre_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $music_genre_query_raw, $music_genre_query_numrows);

Works like a charm! Thanks, Ajeh!

You are most welcome ... thanks for the update that this worked for you ...