/* SELECT */
function select_date($table, $results_per_page){
db_connect();
$query = "SELECT * FROM $table ORDER BY $table.id DESC";
$result = mysql_query($query);
$total = mysql_num_rows($result);
$cur_page = isset($_GET['page']) ? $_GET['page'] : 1;
$num_pages = ceil($total / $results_per_page);
$skip = (($cur_page - 1) * $results_per_page);
$query = $query . " LIMIT $skip, $results_per_page";
$result = mysql_query($query);
$result = db_result_to_array($result);
return $result;
}
/* NAVIGATION FOR PAGES */
function generate_page_links_select(($cur_page, $num_pages){
$page_links = '';
if ($cur_page > 1) {
$page_links .= '<a href="index.php?view=news&page=' . ($cur_page - 1) . '"><-</a> ';
}
else {
$page_links .= '';
}
for ($i = 1; $i <= $num_pages; $i++){
if ($cur_page == $i) {
$page_links .= '<span style="font: 18px Georgia, Times New Roman, Times, serif; color: #0B1944; border: 1px solid #0B1944; padding: 4px 2px 0px 2px;">' . $i . '</span>';
}
else {
$page_links .= ' <a href="index.php?view=news&page=' . $i . '"> ' . $i . '</a>';
}
}
if ($cur_page < $num_pages){
$page_links .= ' <a href="index.php?view=news&page=' . ($cur_page + 1) . '">-></a>';
}
else {
$page_links .= '';
}
if($num_pages > 1){
return $page_links;
}else{
return false;
}
}