sQuery = $sNewQuery; $this->aColumns = $aNewColumns; $this->aColumnNames = $aNewColumnNames; $this->aColumnTypes = $aNewColumnTypes; $this->aHyperLinkURL = $aNewHyperLinkURL; $this->aQueryStringText = $aNewQueryStringText; } function setTableWidth($iNewValue) { $this->iTableWidth = $iNewValue; } function setTextAreaRows($iNewValue) { $this->iTextAreaRows = $iNewValue; } function setTextAreaColumns($iNewValue) { $this->iTextAreaColumns = $iNewValue; } function setTableHeading($sNewValue) { $this->sTableHeading = $sNewValue; } function setRenderIndividualTableForEachResult($bNewValue) { $this->bIndividualTableForEachResult = $bNewValue; } function & render() { global $default; $sql = $default->db; $sql->query($this->sQuery); $sToRender = ""; $sToRender .= "iTableWidth) ? ", width = $this->iTableWidth" : "") . " >\n"; if (isset($this->sTableHeading)) { $sToRender .= "\n"; } if ($sql->num_rows() == 0) { $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; } else { while ($sql->next_record()) { $sToRender .= "\n"; switch ($this->aColumnTypes[$i]) { //plain text field case 1: $sToRender .= "\n"; break; //text area case 2: $sToRender .= "\n"; break; case 3: $sToRender .= "\n"; break; default: break; } $sToRender .= "\n"; } } } $sToRender .= "

aColumns) . "\" align=\"top\">$this->sTableHeading

No " . (isset($this->sTableHeading) ? "$this->sTableHeading" : "") . " data
\n"; for ($i = 0; $i < count($this->aColumns); $i++) { $sToRender .= "
" . $this->aColumnNames[$i] . "	" . stripslashes($sql->f($this->aColumns[$i])) . "	" . $this->aColumnNames[$i] . "	iTextAreaColumns rows=$this->iTextAreaRows READONLY>" . $sql->f($this->aColumns[$i]) . "	" . $this->aColumnNames[$i] . "	aHyperLinkURL[$i] . "?" . $this->replaceValues($this->aQueryStringText[$i], $sql) . "\">" . stripslashes($sql->f($this->aColumns[$i])) . "

\n"; return $sToRender; } function replaceValues($sQueryStringText, $sql) { return $sQueryStringText; } } ?>