I have a MySQL query working on machine #1 but not on the #2.
The query is:
WHERE client_id = 8
AND requests_id IS NULL ORDER BY created
DESC LIMIT 10 OFFSET 10
LIMIT 10 OFFSET 10
As you concluded & asked the same
Sorry guys, just found out I haven't more than 10 entries. So that mean OFFSET won't paginate except you have that number of results? ~ @Filipe
$sql = "SELECT * FROM TableName LIMIT 20";
=> Will will return the first 20 records.
$sql = "SELECT * FROM TableName LIMIT 10 OFFSET 15";
$sql = "SELECT * FROM TableName LIMIT 15, 10";
=> Will return only 10 records, start on record 16 (OFFSET 15)