<?php
class Viewdata extends Connect
{
	
			public function view($param)//$param = ตัวแปร array 
			{
				
				$varibles = array_keys($param);
				$table = @$param['table'];
				$where = @$param['where'];
				$order = @$param['order'];
				$limit = @$param['limit'];
				$count = @$param['count'];
				$txt_where = "";
				$txt_order = "";
				$txt_limit = "";
				$txt_count = "*";
				if($where)
				{
					$txt_where = "WHERE " . $where;
				}
				if($order)
				{
					$txt_order = $order;
				}
				if($limit)
				{
					$txt_limit = "LIMIT ".$limit;
				}
				if($count)
				{
					$txt_count = $count;
				}
				$sql = "SELECT $txt_count FROM $table $txt_where $txt_order $txt_limit";
				
				
				
				return $sql;	
		
			}
			public function q($query)
			{
				$this->setconnect();
				$result = mysql_query($query) or die('Query failed: ' . mysql_error());
				@$row = mysql_fetch_assoc($result);
				return $row;
			}
			public function q_re($query)
			{
				$this->setconnect();
				$result = mysql_query($query) or die('Query failed: ' . mysql_error());
				return $result;
			}
			public function q_ro($result)
			{
				$row = mysql_fetch_assoc($result);
				return $row;
			}
			public function q_nr($result)
			{
				$row = mysql_num_rows($result);
				return $row;
			}						
}
?>