SELECT order.id, order.cntpt, order.gen_expens, order.order_cost, order.cur_payment, order.payment_type, order.date_form, order.death_line, order_productions.prod_name, order_productions.tiraj
FROM `order` 
LEFT JOIN `order_productions` ON order.id = order_productions.order_id
WHERE order.user_id = '" . (int)$_SESSION['user_id'] . "'
ORDER by order.id DESC 
LIMIT " . $limit .  ", 5

$array = array(1,2,3,5,6,7);
$sql = 'SELECT * FROM `page` WHERE `id` IN ('.implode($array,',').')';

$array = array(1,2,3,5,6,7);
$db->where_in('page',$array)->get('page');

public function update($table,$cols,$values,$where) {
		
			if($table == '') die('Вы должны указать таблицу в которой хотите изменить поля');
			if($cols == '') die('Вы должны указать в каких полях хотите сделать изменения');
			if($values == '') die('Вы должны указать новые значения полей');
			if($where == '') die('Вы должны указать WHERE');
			
				$this->select($table,$cols,$where);
				if($this->num > 0) {
			
				if(__MAGIC == 1) {
				
				$where = mysql_real_escape_string(stripslashes($where));
				$table = mysql_real_escape_string(stripslashes($table));
				$cols = mysql_real_escape_string(stripslashes($cols));
				$values = mysql_real_escape_string(stripslashes($values));
				
				} 
				else {
					
				$where = mysql_real_escape_string($where);
				$table = mysql_real_escape_string($table);
				$cols = mysql_real_escape_string($cols);
				$values = mysql_real_escape_string($values);
				
				}
				
				$table = $this->anti_sequriti($table);
				$cols = $this->anti_sequriti($cols);
				$values = $this->anti_sequriti($values,1);
				$where = $this->sql_where($where);
				if(strpos($cols,",") || strpos($values,",")) {
					if((strpos($cols,",") && !strpos($values,",")) || (!strpos($cols,",") && strpos($values,","))) die('Неккоректно перезаписываете поля');
				$cols = explode(",",$cols);
				$values = explode(",",$values);
				$size = sizeof($cols);
				$sizer = sizeof($values);
				if(($size > $sizer) || ($size < $sizer)) {
					die('Разное количество изменяемых полей');
					unset($sizer);
					}
				for($i = 0; $i < $size; $i++) {
					if($i < $size - 1) $in = ','; else $in = NULL;
					$pols .= $cols[$i] . '=' . $values[$i] . $in;
				}
				} else 		$pols = $cols . '=' . $values;
				
				$query = "UPDATE " . $table . " SET " . $pols . " WHERE " . $where;
				echo htmlspecialchars($query) . "<br>";
				$this->result = mysql_query($query);
				
				if($this->result) return true;
				else {
					$this->errno = mysql_errno();
					$this->error = mysql_error();
					$this->errors();
					return false;
				}
				}
					
	}

function update($tabl,$value,$where) {
	if(! is_array($value)) {
		die('Ne massiv');
	}
	
	foreach($value as $keys=>$vals) {
		$key[] = mysql_real_escape_string($keys);
		$val[] = mysql_real_escape_string($vals);
	}
	$keys = implode($key,',');
	$vals = implode($val,'","');
	
	// и т.д. думаю вы поняли
	/*
	* в массиве $value передаем данные типа
	* ключ (Поле для замены) => значение (значение поля для замены)
	*/
}

$data->update('test','title,id','testim,1','id=1');

$data = mysql_query("UPDATE `test` SET `title` = '".$text."', `id` = '".$text2."' WHERE id=1");

				$table = $this->anti_sequriti($table);
				$cols = $this->anti_sequriti($cols);
				$values = $this->anti_sequriti($values,1);
				$where = $this->sql_where($where);
				if(strpos($cols,",") || strpos($values,",")) {
					if((strpos($cols,",") && !strpos($values,",")) || (!strpos($cols,",") && strpos($values,","))) die('Неккоректно перезаписываете поля');
				$cols = explode(",",$cols);
				$values = explode(",",$values);
				$size = sizeof($cols);
				$sizer = sizeof($values);
				if(($size > $sizer) || ($size < $sizer)) {
					die('Разное количество изменяемых полей');
					unset($sizer);
					}
				for($i = 0; $i < $size; $i++) {
					if($i < $size - 1) $in = ','; else $in = NULL;
					$pols .= $cols[$i] . '=' . $values[$i] . $in;
				}
				} else 		$pols = $cols . '=' . $values;

<?php
//author Snus

	class vQuery {

		public $query;
		private $leftTags;
		private $nTags;
		private $repF;
		private $repT;

		public function __construct(){
			$this->leftTags = array('SELECT','AS','FROM','WHERE','ORDER','GROUP','BY','INNER','LEFT','JOIN','ON','UNION','DROP','TRUNCATE','TABLE','LIKE','LIMIT','RIGHT','*','=',',','.','>','<','!=','<>');
			$this->nTags = array('FROM','WHERE','ORDER','GROUP','INNER','LEFT','LIMIT');
			$this->repF = array('=', ',','  ','`','"');
			$this->repT = array(' = ',' , ',' ','','\'');
		}

		public function q($q){
			$exp = explode(' ', $this::r($q));
			foreach($exp as $key => &$val){
				$val = trim($val);
				if(!in_array(strtoupper($val), $this->leftTags) && !strpos($val, '\'', 1) && !strpos($val, '.', 1))
					$exp[$key] = '`'.$val.'`';
				else if(in_array(strtoupper($val), $this->leftTags) && strtoupper($exp[$key-1]) != 'FROM')
					$exp[$key] = strtoupper($val);
				else if(substr_count($val, '\'') > 2){
					$match = preg_match('/\'(.*)\'/', $val, $matches);
					$exp[$key] = '\''.addslashes($matches[1]).'\'';
				}

				if(in_array(strtoupper($val), $this->nTags))
					$exp[$key] = "\n".$val;

			} 
			$this->query = implode(' ', $exp);
		}

		private function r($q){
			return str_replace($this->repF, $this->repT, $q);
		}

		public function dump(){
			echo '<pre>';
				echo $this->query;
			echo '</pre>';
		}

	}

?>

$query = "select fdsfsd,dbsa.db,sdfsdf from mytable AS tbl inner join dbsa as s on s.id=tbl.id where tag=bit";
$vQuery = new vQuery();
$vQuery->q($query);

echo $vQuery->query;
$vQuery->dump();

SELECT `fdsfsd` , dbsa.db , `sdfsdf` FROM `mytable` AS `tbl` INNER JOIN `dbsa` AS `s` ON s.id = tbl.id WHERE `tag` = `bit`

SELECT `fdsfsd` , dbsa.db , `sdfsdf` 
FROM `mytable` AS `tbl` 
INNER JOIN `dbsa` AS `s` ON s.id = tbl.id 
WHERE `tag` = `bit`