Data from serverside not display

Question

hello guys i try data use datatables from serverside (SQL Server) if me use code my data not found or not availaible. this is my code

$sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]."   ".$requestData['order'][0]['dir']."   LIMIT ".$requestData['start']." ,".$requestData['length']."   ";

please help me

You could echo your sql string and check the data and grammar. — Phil, Oct 16 '18 at 01:56
I saw `LIMIT` keyword in there. Are you mixing `SQL Server` with `MySQL` ? — Squirrel, Oct 16 '18 at 02:08

score 1 · Accepted Answer · answered Oct 16 '18 at 05:17

1

Use OFFSET and FETCH in SQL Server OFFSET FETCH Clause.

SELECT * FROM table ORDER BY column OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY;

Possible duplicate: LIMIT 10..20 in SQL Server.

answered Oct 16 '18 at 05:17

oerl

1,204
14
16

Data from serverside not display

1 Answers1