Search

state information about the table (page.info(), etc) and save

As long as $('#example').DataTable() executes when the id=example element is in the document then it will work. If you place the script after the table element, that should be just fine. Allan

multiple loops through the table will not create a

way you configured your table and columns applies to

Just to confirm - this will be in the next version of Editor. Mjoin will have an order() method which you can use to specify which property of the joined table should be used to order the data. Regards, Allan

of rows in the table body? That would be

got it... $search = $_POST['search']; if (!empty($search['value'])) { $sql .= " Having searchField like '%".$search['value']."%'"; } $orderBy = $_POST['order']; $orderCol = intval($orderBy[0]['column']); $sql .= " order by " . $orderCol . " " . $orderBy[0]['dir']; where searchField is a concat of all the fields displayed in the table.

DataTables warning: table id=example - INVALID JSONresponse example is not the ID being passed happens around record 100

used for any simple table, and will share that

this only happens when table is initialized. If i