db = $db;
$this->tabledefid = (int) $tabledefid;
}//end function
function display(){
$querystatement = "
SELECT
`querytable`
FROM
`tabledefs`
WHERE
id=".$this->tabledefid;
$queryresult = $this->db->query($querystatement);
$thetabledef = $this->db->fetchArray($queryresult);
//Grab query for all columns
$querystatement = "
SELECT
*
FROM
".$thetabledef["querytable"]."
LIMIT 1";
$queryresult = $this->db->query($querystatement);
$numfields = $this->db->numFields($queryresult);
for ($i=0;$i<$numfields;$i++)
$fieldlist[]=$this->db->fieldTable($queryresult,$i).".".$this->db->fieldName($queryresult,$i);
?>
match of the following rules:
sql where clause
display();
?>