How to use retrive data from multiple and filter the data

SandeepMurala

HI ,
I am new to this dataTable concept i am taking the code from this https://datatables.net/examples/data_sources/server_side.html
In this the server.php file my code like this

$table = "Test";
 array( 'db' => 'test_column','dt' => 0 ,'formatter' => function( $d, $row )
        {
               $hostname='localhost';
            $user = 'root1';
            $password = '';
            $mysql_database = 'Demo';
            $db = mysqli_connect($hostname, $user, $password,$mysql_database);
                mysqli_select_db($db,$mysql_database);
            if (mysqli_connect_errno())
          {
           die("Connection failed: " . mysqli_connect_error());
          }
            $sel = "select userl,campaign from Test1 where extenl = '$d' and datel <='$row[4]' order by datel desc limit 1";
            $res = mysqli_query($db,$sel);
            $rw = mysqli_fetch_array($res);
            return $rw[0];  //this is return the values of Users
        },
        )

This code working file but problem is when i search the column is not working bez I am searching users but the column i have taken test_column give me solution for this
how can take the values from Test table and filter in Test1 table but the column should name by user ,how can we do like this or any alter native ideas over there kindly let me know please .

Thanks
Sandeep

colin

These threads should help, here and here, they're asking the same thing.

Cheers,

Colin