<?php

$page = (isset($_GET['page']) && is_numeric($_GET['page'])) ? (int) $_GET['page'] : 1;
$max_results = 1000;
$from = ($page * $max_results) - $max_results;

if(strlen($_GET['letter']) == 1) { 
	$result = dbQuery("SELECT COUNT(word) AS counter FROM keywords WHERE amount > 0 AND `word` LIKE '$_GET[letter]%'", true);
	$total_results = $result[0]['counter'];
	$result = dbQuery("SELECT * FROM keywords WHERE amount > 0 AND `word` LIKE '$_GET[letter]%' ORDER BY `word` ASC LIMIT $from,$max_results", true);
	$total_pages = ceil($total_results / $max_results);
} else { 
	$result = dbQuery("SELECT COUNT(word) AS counter FROM keywords WHERE amount > 0", true);
	$total_results = $result[0]['counter'];
	$result = dbQuery("SELECT * FROM keywords WHERE amount > 0 ORDER BY `word` ASC LIMIT $from,$max_results", true);
	$total_pages = ceil($total_results / $max_results);
}
?>