How to use 'Where' in server side processing sample

swf

I'd just like to display a table with a SQL Statement like this: "Select * from mytable WHERE active = 1"

Are there any samples how add a WHERE statement to the server side processing sample?

swf

After hours of testing other code, the solution was simpler than expected. Just adding the WHERE statement into:

/*
* SQL queries
* Get data to display
*/
$sQuery = "
SELECT SQL_CALC_FOUND_ROWS ".str_replace(" , ", " ", implode(", ", $aColumns))."
FROM $sTable
WHERE active = 1 AND NOW() >= activeDate
$sWhere
$sOrder
$sLimit
";

Seems to work ...