# --------------------------------------------------------------------
function show_table($order,$id,$npages,$nrows,$max_rows,$from,$to) {
  if ($to > $max_rows) $to = $max_rows - $from;
  # use mysql's "limit from,to" to select the correct rows
  $query = "select imagepath,title,description from pagination_images order by " . $order . " limit " . $from . "," . $to;
  $result = mysql_query($query) or show_error("Query failed: " . mysql_error());
  $numrows=mysql_num_rows($result);
  if ($numrows > 0) {
    # create table with id = "media"
    echo "<table id=\"media\"><thead>\n";
    echo "<tr>";
    echo "<th class=\"imagepath\"><a href=\"#\">Image</a></th>";
    echo '<th class="title"><a onmouseover="this.style.cursor=\'pointer\';" onclick="sorted_rows(\'title\',' . $id . ',' . $npages . ',' . $nrows . ',' . $max_rows . ');">Title</a></th>' . "\n";
    echo '<th class="description"><a onmouseover="this.style.cursor=\'pointer\';" onclick="sorted_rows(\'description\',' . $id . ',' . $npages . ',' . $nrows . ',' . $max_rows . ');">Description</a></th>' . "\n";
    echo "</tr>\n";
    $count=0;
    # a little magic to start showing the correct pages
    # the idea is to determine the start (and end, but that's just the end of the while-loop)
    # of the current pagination, determined by $id
    # for example: if our id = 3 and we show 10 pages per block the pages are from 1 - 10
    #              if our id = 21 and we show 10 pages per block the pages are from 21 - 30
    #              if our id = 20 and we show 10 pages per block the pages are from 11- 20
    $pagecount = $id - ($id%$npages - 1);
    if ($id%$npages == 0) $pagecount = $pagecount - $npages;

    # lower pagecount because a bit further  we do a "pagecount++" before using it.
    $pagecount -= 1;
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
      if ($count%$nrows == 0) {
        $pagecount++;
        if ($pagecount == $id) {
          # this tbody (page) will be visible
          echo "<tbody id=\"tbody" . $id . "\" style=\"display:table-row-group\">\n";
        } else {
          # these tbody's (pages) are hidden
          echo "<tbody id=\"tbody" . $pagecount . "\" style=\"display:none\">\n";
        }
      }
      # data for tbodyX
      # make even/odd rows a different color
      if ($count%2 == 0) {
        echo "<tr class=\"even\">";
      } else {
        echo "<tr class=\"odd\">";
      }
      echo "<td style=\"width:300px\"><img alt=\"" . addslashes($line['title']) . "\" src=\"/blog/" . $line['imagepath'] . "\"/></td>";
      echo "<td style=\"width:200px\">" . $line['title'] . "</td>";
      echo "<td style=\"width:300px\">" . $line['description'] . "</td>";
      echo "</tr>\n";
      $count++;
    }
    echo "</table>\n";
  }
}