<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
	/*
	 *	WSI Flat Table Manager SELECT functions
	 * (C)2003 WSI, ALL RIGHTS RESERVED. E-mail: support@webbstyle.com
	 * Version stable 0.1
	 *
	 * Flat File Database Engine
	*********************************************************************************************/

	if (!defined("DB_ERRORMSG_101")) { define ("DB_ERRORMSG_101", "ERROR 101 SQL-string not valid."); }

	function &_select(&$thiz, $sqlstring) {

		$rs = true;
		$sql_org = $sqlstring;
		//echo 	$sqlstring;
		$sp=&$thiz->sp;
        $sp->setString($sqlstring);
		if(!$sp->queryIsCached )
		{
		$vals=$sp->parseSqlQuery();
		$thiz->newqcache($sqlstring,$vals);
		}else 
		{
		$vals=$sp->queryObjectCache;
		}
		$sqlarray['select']=$vals->colNames;
		$sqlarray['from']=$vals->table;
		$sqlarray['where']=$vals->where_expr;
		$sqlarray['orderby']=$vals->orderColumn.$vals->orderType;
		$sqlarray['select'] == '*' ? $cols = '' : $cols = explode (",", $sqlarray['select']);

			// set search string
			isset ($sqlarray['where']) ? $search = $sqlarray['where'] : $search = '';
			// get recordset
			include_once('read_table.php');
			is_array ($sqlarray) ? $rs = _read_table($thiz, $thiz->db_name.$sqlarray['from'], $cols, $search) : $rs = DB_ERRORMSG_101;
			// order recordset if exists
			if (count ($thiz->rowset) > 1 && isset ($sqlarray['orderby']) && $sqlarray['orderby']!="") {

				if (strpos ($sqlarray['orderby'], "+")) {

					$sqlarray['orderby'] = "+".rtrim ($sqlarray['orderby'], "+");

				} elseif (strpos ($sqlarray['orderby'], "-")) {

					$sqlarray['orderby'] = "-".rtrim ($sqlarray['orderby'], "-");

				} else {

					$sqlarray['orderby'] = "+".$sqlarray['orderby'];

				}

				include_once('sort_rs.php');
				$thiz->rowset = _sortrecordset($thiz, $thiz->rowset, explode (",", $sqlarray['orderby']));

			}

		return $rs;

	}

?>