datatables and tabletools

[Rohithzr]

I definitely looked up on datatables.net but could not really get a good answer.So here i go:

what i have: currently i have a datatable that loads data and populates the table through this loop > echo '<td>'.$mydata.'</td>';

what table has: 1: I execute an sql query then populate 8 columns, 9th column is populated through another inline looped query, 10th column is a tool table that is fixed with a variable in its href : <a href="toolpage.php?xId=<?php echo 'echo $row["xId"]; ?>">tool</a>

what i achieved : i was able to get the first 8 columns on server side working fine

what i want : the rest of the two columns with the other 8.

files : link to 4 files

[Rohithzr]

function getBalance($cId){
    $qry = "SELECT COUNT( 
            STATUS ) AS balstatus
            FROM payments
            WHERE STATUS = 1
            AND cId = ".$cId.";";
    $res = mysql_query($qry);
    return $res;
}

this is the inline looped query i was reffering to

[Author]

Posts