select.php

	/**
	 * Count records for a given table
	 *
	 * @param  string  table name
	 * @param  array   WHERE conditions
	 * @return int
	 */
	public function count_records($table = FALSE, $where = NULL)
	{
		$this->_select = array(array('COUNT("*")', 'records_found'));

		if (count($this->_from) < 1)
		{
			if ($table === FALSE)
				throw new Database_Exception('Database count_records requires a table');
			$this->from($table);
		}

		if ($where !== NULL)
		{
			$this->where($where);
		}

		$result = $this->execute()->current();

		return $result['records_found'];
	}