<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

	
	/**************************************************************************************************/
	/***** Result Set Formatting Functions ************************************************************/
	
	function rset( $q ) {
		if ($q->num_rows() >= 1) {
			$arr = array();
			for ($i=0; $i < $q->num_rows(); $i++) {
				$r = $q->result_array();
				$arr[count($arr)] = $r;		
			}
			return $arr[0];
		} else return false;
	}
	
	/* QCOL returns an single script array of values in a column */
	/* great for selecting one field and expecting multiple records in return */
	function qcol( $q ) {
		$r = rset( $q );
		if (!isset($r[0])) return false;
		else {
			$out = array();
			foreach ( $r as $x ) {
				foreach ( $x as $key => $val) {
					$out[] = $val;
				}
			}
			return $out;
		}
	}
	
	function qrow( $q, $row=0 ) {
		$r = rset( $q );
		if (!isset($r[$row])) return false;
		else return $r[$row];
	}
	
	function qsql( $q ) {
		if ($q->num_rows() == 0) return false;
		else {      
			$r = $q->result_array();
			$r = $r[0];
			foreach ($r as $k => $v) return $v;
		}
	}
	
	function qin( $a ) {
		$in = '(';
		for ($i=0; $i < count($a); $i++) {
			if ($i > 0) $in .= ',';
			$in .= "'".$a[$i]."'";
		}
		$in .= ')';
		return $in;
	}
	
	
	function datetime( $unix = false ) {
		if (!$unix) $unix = time();
		return date('Y-m-d H:i:s', $unix);
	}
	
	/**************************************************************************************************/
	/**************************************************************************************************/

?>