Ajax DataGrid Support Product Page
Answered
include DISTINCT in SQL
Asked 10 Dec 2012 23:09:23
1
has this question
10 Dec 2012 23:09:23 Andrew Gray posted:
how and where can I include a DISTINCT statement in the SQL to filter the data grid in this manner?regards
AndyG.
Replies
Replied 29 Mar 2013 07:57:08
29 Mar 2013 07:57:08 Miroslav Zografski replied:
Hello Andrew,
The SQL query is build in ajax_servers/dmx_grid#.php.
The SQL is dynamically generated and is glued together in following line:
$sql = "SELECT $cols FROM $table $where $order $limit";
There you could add to the query some stuff.
Regards.
The SQL query is build in ajax_servers/dmx_grid#.php.
The SQL is dynamically generated and is glued together in following line:
$sql = "SELECT $cols FROM $table $where $order $limit";
There you could add to the query some stuff.
Regards.