sQuery = $sTmpQuery; $this->aColumns = & $aTmpColumns; $this->aColumnTypes = $aTmpColumnTypes; $this->aColumnHeaderNames = $aTmpColumnHeaderNames; $this->sWidth = $sTmpWidth; $this->sWhereClause = & $sTmpWhereClause; $this->sOrderByClause = $sTmpOrderByClause; $this->bDisplayColumnHeadings = $bTmpDisplayColumnHeadings; $this->aColumnEditable = $aTmpColumnEditable; $this->sTableName = $sTmpTableName; $this->sUniqueName = $sTmpUniqueName; } function setTableHeading($sNewValue) { $this->sTableHeading = $sNewValue; } function & render() { //$sToRender = "sWidth>\n"; $sToRender = "\n"; if (isset($this->sTableHeading)) { $sToRender .= "\n"; } if ($this->bDisplayColumnHeadings) { for ($i = 0; $i < count($this->aColumnHeaderNames); $i++) { $sToRender .= "\n"; } } $sql = new Owl_DB(); $sql->query($this->sQuery); if ($sql->num_rows() == 0) { $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; } else { while ($sql->next_record()) { $sToRender .= "\n"; for ($i = 0; $i < count($this->aColumns); $i++) { switch ($this->aColumnTypes[$i]) { case 1: $sToRender .= "\t\n"; break; default: break; } } $sToRender .= "\n"; } } $sToRender .= "

$this->sTableHeading

" . $this->aColumnHeaderNames[$i] . "
No " . (isset($this->sTableHeading) ? $this->sTableHeading : "") . " data
\n"; if ($this->aColumnEditable[$i]) { //$this->aVariableArray[$this->iVariableCount] = $this->sUniqueName . "_" . $this->iVariableCount; $sToRender .= "\t\tsUniqueName . "_" . $this->iVariableCount . "\" value=\"" . $sql->f($this->aColumns[$i]) . "\" />\n"; $sToRender .= "\t\tsUniqueName . "_" . $this->iVariableCount . "_id\" value=\"" . $sql->f("id") . "\" />\n"; $sToRender .= "\t\tsUniqueName . "_" . $this->iVariableCount . "_tn\" value=\"" . $this->sTableName . "\" />\n"; $this->iVariableCount++; } else { $sToRender .= "\t\t" . $sql->f($this->aColumns[$i]) . "\n"; } $sToRender .= "\t

"; return $sToRender; } } ?>