####################################################################### PHP
Offset: -25
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-25, 25' at line 1
####################################################################### PHP
function listUsers() {
$entries_per_page = 25;
$result = mysql_query("SELECT COUNT(*) AS user_id FROM users") or die(mysql_error());
$row = mysql_fetch_row($result);
$total_entries = $row[0];
if(isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$total_pages = ceil($total_entries / $entries_per_page);
$offset = ($page - 1) * $entries_per_page;
echo "Offset: " . $offset . "
";
$result = mysql_query("SELECT * FROM users LIMIT $offset, $entries_per_page") or die(mysql_error());
echo "