<?php
include("../connect.php");
if ($_POST['test']){
    $id = intval($_POST['test']);
    $query = "SELECT id_block FROM `block` WHERE id_test='$id' AND status=1 ORDER BY `order`";
    $sql = mysql_query($query) or die(mysql_error());
    $arr = array();
    $query_type = "SELECT id_type FROM `test` WHERE id_test='$id'";
    $sql_type = mysql_query($query_type) or die(mysql_error());
    $type = mysql_fetch_assoc($sql_type);
    $arr[type] = $type;
    while ($row = mysql_fetch_assoc($sql)) {
            $arr[block][] = $row;
            $query2 = "SELECT random FROM `block` WHERE id_block='$row[id_block]'" ;
            $sql2 = mysql_query($query2) or die(mysql_error());
            $row2 = mysql_fetch_row($sql2);
                    if ($row2[0] == 0) {
                    $query3 = "SELECT  question.id_block, question.question_1, question.question_2, question.value_1, question.value_2, question.id_category, block.instruction  FROM `question` LEFT JOIN `block` ON question.id_block=block.id_block WHERE question.id_block='$row[id_block]' ORDER BY question.order";
                    $sql3 = mysql_query($query3);
                        while ($row3 = mysql_fetch_assoc($sql3)) {
                        $arr[data][] = $row3;
                        }
                    }
                    else {
                    $query4 = "SELECT  question.id_block, question.question_1, question.question_2, question.value_1, question.value_2, question.id_category, block.instruction  FROM `question` LEFT JOIN `block` ON question.id_block=block.id_block WHERE question.id_block='$row[id_block]' ORDER BY RAND() ";
                    $sql4 = mysql_query($query4);
                        while ($row4 = mysql_fetch_assoc($sql4)) {
                        $arr[data][] = $row4;
                        }
                    }
    };
    $data = json_encode($arr);
    echo $data;
}
?>