WHERE clause in the first load

prieku

How to filter datatables in the first load with WHERE clause of some "id" using server side ?

example basic query:
$sql = mysql_ query("SELECT * FROM table1 WHERE idcategory = $_GET[id]";

I need show data where i'm set on idcategory = $_GET[id]
that's it.

kthorngren

You can set search with your initial search. It will be performed when Datatables initializes.

Kevin