sql_query($query2); $row = $db->sql_fetchrow($res); $total = $row[0]; } else{ $query = "SELECT * FROM " . TABLE_PAPERS . " ORDER BY " . $order_by . " LIMIT " . $offset . "," . $num_res; $query2 = "SELECT COUNT(*) FROM " . TABLE_PAPERS; $res = $db->sql_query($query2); $row = $db->sql_fetchrow($res); $total = $row[0]; } //echo $query; if ( !($result = $db->sql_query($query)) ){ message_die(GENERAL_ERROR, 'no results', '', __LINE__, __FILE__, $query); } ?>
">Browse All
SORT BY:
10' : '10'; $two5 = (empty($num_res) || $num_res == 25) ? '25' : '25'; $five0 = (empty($num_res) || $num_res == 50) ? '50' : '50'; ?> Results per page: | |
$total) ? $total : ($offset + $num_res); echo 'Total results: ' . $total . "
\n"; echo 'Results ' . $start . '-' . $end . ' shown'; } echo '
    '; $tmp = $offset + 1; while($row = $db->sql_fetchrow($result)){ if($tmp == $offset+1){ echo '
  1. '; $tmp++; } else{ echo '
  2. '; } echo display_paper($row); echo "
    3. \n"; } echo "
\n
\n"; ?> ">Browse All
SORT BY:
10' : '10'; $two5 = (empty($num_res) || $num_res == 25) ? '25' : '25'; $five0 = (empty($num_res) || $num_res == 50) ? '50' : '50'; ?> Results per page: | |