Server-Side Processing - Adding Where Clausule

Server-Side Processing - Adding Where Clausule

jandantejandante Posts: 10Questions: 4Answers: 0
edited June 2011 in DataTables 1.8
First of all => Very nice software!

I'm probably missing this in your Examples but what if i want to work with server-side processing like here: http://datatables.net/release-datatables/examples/data_sources/server_side.html

But i want to add a WHERE clausule to the query. for example: "Select all users From tblUsers where active = 1". Do I have to make changes in the Php file or can i pass this on with a variable?

Thanks in advance!

Replies

  • allanallan Posts: 63,368Questions: 1Answers: 10,449 Site admin
    You have to change the PHP. You'd need to alter the where building block around line 86, assuming you are using this script: http://datatables.net/development/server-side/php_mysql

    Allan
This discussion has been closed.