<?
#######################################################################
########### Instanciando a classe dataTable
#######################################################################
include('dataTable.class.php');
$sql = "
select top 100 *
from myTable MT
inner join anOtherTable OT on
MP.anField = OT.otherField
where MP.anField is not null
order by TP.thirdField
";
$config = array(
'host'=>'192.000.000.***',
'usr'=>'*********',
'pass'=>'*******',
'db'=>'MyDataBase',
'sql'=>$sql,
'errorPage'=>'',
'clLine_pair'=>'#EEEEEE',
'clLine_odd'=>'#CCCCCC'
);
$dt = new dataTable($config);
?>
|