<?
/*
    PHP Table class - Data aquisition and rendering framework
    Copyright (C) 2002 Richard Clark (rclark@exorsus.net)

    See the GNU General Public License included with this software
    for more details. If none is included you have NO LICENSE to
    operate this software and should contact the author immediately.
 */

require_once('table_data.inc');

class Table_Data_MySQL extends Table_Data {
	var $dbh;

	function Table_Data_MySQL($dbh, $q, $fields, $default_orderby="") {

		$this->dbh = $dbh;

		parent::Table_Data($q, $fields, $default_orderby);

		if ($this->orderby && !preg_match('/order by/',$q)) {
			$this->data_source .= " order by ".$this->orderby;
		}
	}

	function aquire() {
		if (!($result = mysql_query($this->data_source, $this->dbh))) {
			return;
		}
		while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
			$this->add_row($row);
		}
	}

}

?>