sQuery = $sTmpQuery; $this->aColumns = & $aTmpColumns; $this->aColumnTypes = $aTmpColumnTypes; $this->aColumnHeaderNames = $aTmpColumnHeaderNames; $this->sWidth = $sTmpWidth; $this->sWhereClause = & $sTmpWhereClause; $this->sOrderByClause = $sTmpOrderByClause; $this->bDisplayColumnHeadings = $bTmpDisplayColumnHeadings; } function setTableHeading($sNewValue) { $this->sTableHeading = $sNewValue; } /** * Build the HTML string used to render the object * * @return String of HTML used to render object * * @todo possibly add in image size restraints for link types 2 and 3 */ 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 .= ""; break; default: break; } } $sToRender .= "\n"; } } $sToRender .= "

$this->sTableHeading

" . $this->aColumnHeaderNames[$i] . "
No " . (isset($this->sTableHeading) ? $this->sTableHeading : "") . " data
" . $sql->f($this->aColumns[$i]) . "

"; return $sToRender; } } ?>