DataTables & Custom SQL

drrock

So no solutions for Search issue?

I realize the server_processing.php example is separate from DataTables but in general would it be fair to say that you cannot use custom SQL (in particular table joins) in conjunction with DataTables?

I've read other posts that involve custom SQL in conjunction with server side processing and many if not all run into the same Search issue.

fbas

side note: I too do not have json installed oh PHP (5.1). but someone pointed me to http://www.boutell.com/scripts/jsonwrapper.html for a library that gives you json_encode()

uvaldez

If you want to search using one column just use in the where section something like this

$sWhere = " where promo_title like '%" $_GET['sSearch_'.$i] "%' ";