function TableBySql($sql)
{
$this->NAME = "Table";
$this->XPOS = "";
$this->YPOS = "";
$this->WIDTH = "100%";
$this->HEIGHT = 0;
$this->BORDER = 0;
$this->setPadding(0);
$this->setSpacing(0);
$this->COLSIZES = array();
$this->ROWS = array();
$this->FONTTYPES = array();
$this->DESIGNJN = "N";
$this->TABLEDESIGN = "default";
$this->DESIGNWIDTH = 20;
$this->DESIGNHEIGHT = 20;
$this->HEAD_ENABLED = true;
$this->DBCONNECT = $_SESSION['config']->DBCONNECT;
$this->SQL = $sql;
$result = $this->DBCONNECT->executeQuery($this->SQL);
$menge = mysql_num_fields($result);
// SpaltenNamen holen
for ($x = 0; $x < $menge; $x++) {
$cN[$x] = mysql_field_name($result, $x);
}
$this->COLNAMES = $cN;
$this->prepareFonts();
//Select-Ergebniss in Rows *packen*
while ($rowArray = @mysql_fetch_array($result)) {
$newRow = $this->createRow();
if (strlen($this->getVAlign()) > 0) {
$newRow->setVAlign($this->getVAlign());
}
if (strlen($this->getAlign()) > 0) {
$newRow->setAlign($this->getAlign());
}
for ($i = 0; $i < count($this->COLNAMES); $i++) {
if (mysql_field_type($result, $i) == "blob") {
$txa = new TextArea("txt", $rowArray[$i]);
$txa->setWidth(40);
$txa->setHeight(3);
$txa->setReadOnly(true);
$newRow->setAttribute($i, $txa);
} else {
$newRow->setAttribute($i, new Text($rowArray[$i]));
}
}
$this->addRow($newRow);
}
}
