Using multiple tables gives me a error with searchable variables
Using multiple tables gives me a error with searchable variables
Denonth
Posts: 76Questions: 0Answers: 0
Hi all,
I am using this DataTables to fill my tables with data. When I tried to load data from one data everything works nicely. But when I add more tables to it it won't show me data. I get error with searchable variables.
For example:
[code]
$aColumns = array( 'FROM_UNIXTIME(a.timestamp)', 'b.ID', 'c.Name','d.Lastname' );
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "b.ID";
/* DB table to use */
$sTable = "a,b,c,d";
[/code]
Now I have where part and I put it here:
[code]
/*
* Filtering
* NOTE this does not match the built-in DataTables filtering which does it
* word by word on any field. It's possible to do here, but concerned about efficiency
* on very large tables, and MySQL's regex functionality is very limited
*/
$sWhere = "a.ID=b.ID AND c.name=a.name_a"; //and so on
if ( $_GET['sSearch'] != "" )
{
$sWhere = "WHERE (";
for ( $i=0 ; $i
I am using this DataTables to fill my tables with data. When I tried to load data from one data everything works nicely. But when I add more tables to it it won't show me data. I get error with searchable variables.
For example:
[code]
$aColumns = array( 'FROM_UNIXTIME(a.timestamp)', 'b.ID', 'c.Name','d.Lastname' );
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "b.ID";
/* DB table to use */
$sTable = "a,b,c,d";
[/code]
Now I have where part and I put it here:
[code]
/*
* Filtering
* NOTE this does not match the built-in DataTables filtering which does it
* word by word on any field. It's possible to do here, but concerned about efficiency
* on very large tables, and MySQL's regex functionality is very limited
*/
$sWhere = "a.ID=b.ID AND c.name=a.name_a"; //and so on
if ( $_GET['sSearch'] != "" )
{
$sWhere = "WHERE (";
for ( $i=0 ; $i
This discussion has been closed.