update orders
	join (select $id1 id, $request1 request from dual
            union all
            select $id2, $request2 from dual) data
            on orders.id=data.id
    set request=data.requestDELIMITER $$
 
CREATE PROCEDURE build_email_list (INOUT email_list varchar(4000))
BEGIN
 
 DECLARE v_finished INTEGER DEFAULT 0;
        DECLARE v_email varchar(100) DEFAULT "";
 
 -- declare cursor for employee email
 DEClARE email_cursor CURSOR FOR 
 SELECT email FROM employees;
 
 -- declare NOT FOUND handler
 DECLARE CONTINUE HANDLER 
        FOR NOT FOUND SET v_finished = 1;
 
 OPEN email_cursor;
 
 get_email: LOOP
 
 FETCH email_cursor INTO v_email;
 
 IF v_finished = 1 THEN 
 LEAVE get_email;
 END IF;
 
 -- build email list
 SET email_list = CONCAT(v_email,";",email_list);
 
 END LOOP get_email;
 
 CLOSE email_cursor;
 
END$$
 
DELIMITER ;По учебнику Трепачева кстати, да и везде стоит сначала session_start(), и это должно быть правильно.
<?php 
if (isset($_POST['do_changes'])){ 
    session_start(); 
    $user = R::findOne('users', 'id = ?', [ $_SESSION['logged_user']['id'] ] ); 
    $user->name = $_POST['new_name']; 
    $user->email = $_POST['new_email']; 
    $user->phone = $_POST['new_phone']; 
    R::store($user); 
}      $query = mysql_query("INSERT INTO `subs` VALUES ($login,$pass)");
WITH recursive hours (n) AS (
    SELECT (@q:=0) n FROM dual
    UNION ALL
    SELECT (@q:=@q+1) n FROM hours WHERE @q<24
)
SELECT hours.n, ваш_запрос.* FROM ваш_запрос
    RIGHT JOIN hours ON ваш_запрос.час = hours.nWITH recursive hours (n) AS (
    SELECT CONCAT("0",CAST(@q:=0 as varchar(1))) n FROM dual
    UNION ALL
    SELECT LPAD(CAST(@q:=@q+1 as varchar(2)),2,"0") n FROM hours WHERE @q<24
)
SELECT hours.n, ваш_запрос.* FROM ваш_запрос
    RIGHT JOIN hours ON  ваш_запрос.час = hours.n      function format($size,$prefix=0){
	if (is_numeric($size) && $size>=1000 && $prefix<8) {
		$size = format(floor($size/1000),$prefix+1);
		return $size;
	} else {
		$prefixName = ["B","KB","MB","GB","TB","PB","EB","ZB","YB"];
		return $size . $prefixName[$prefix];
	}
}      SELECT
        CASE WHEN status="В наличии" THEN 1
            WHEN status="На заказ" THEN 2 
            WHEN status="Нет в наличии" THEN 3
            ELSE null END sort_id,
            *
    FROM table$result_array=[];
foreach (array_keys($array1) as $key){
      $result_array[$key]=$array2[$key];               
}
var_dump($result_array);