Server Side Processing: complex query

olefrank

I'm trying to use this query.

SELECT SQL_CALC_FOUND_ROWS IF(variant_title != '', variant_title, 'N/A') AS Title, prod_id, variant_id
FROM variants
GROUP BY prod_id, variant_id, variant_title

I'm using the 'Server Side Processing Example' (http://datatables.net/release-datatables/examples/server_side/server_side.html)

I don't know how to insert my query in the php.

Hope someone can help!

Best regards
Ole