Untitled

$query_resp = mysql_query("SELECT *
     FROM
        respostas
             WHERE
               resp_usuario='$id_usuario'
                 AND resp_questionario='$quest'
                 AND resp_area='$area'
                 AND resp_subgrupo='$subgrupo'
                 AND resp_loja='$loja'
                 AND resp_pergunta_id='$idpergunta'")or die(mysql_error());
    while ($row = mysql_fetch_array($query_resp)) {
    $resposta   = $row['resp_resposta'];
    $st         = $row['resp_status'];
     }
    echo"<div class'form-group'>";
    echo"<div class='col-lg-10 col-lg-offset-2'>";

if ($status == "1") {
        echo"<center><h4>PERGUNTA JA RESPONDIDA | RESPOSTA:$resposta</h4></center>";
     } else {
        echo"<center><button  type='submit' class='btn btn-danger'>REPONDER</button></center><br />";
       }
        echo"</div>";
     echo"</div>";
      var_dump($query_resp);

<?php
ini_set('display_errors',true);
error_reporting(E_ALL);
?>

<?php
// A sessÃ£o precisa ser iniciada em cada pÃ¡gina diferente
if (!isset($_SESSION)) session_start();
// Verifica se nÃ£o hÃ¡ a variÃ¡vel da sessÃ£o que identifica o usuÃ¡rio
if (!isset($_SESSION['usu_login'])) {
  // DestrÃ³i a sessÃ£o por seguranÃ§a
  session_destroy();
  // Redireciona o visitante de volta pro login
  header("Location: logout.php"); exit;
}
?>
<?php
require("conexao.php");
?>
<html>
  <head>
    <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
            <meta name="viewport" content="width=device-width, initial-scale=1">
            <title>CHECKLIST LOJAS</title>
            <link href="includes/bootstrap.min.css" rel="stylesheet">
            <link href="includes/css/bootstrap.min.css" rel="stylesheet">
  </head>
<body>
<?php
// SESSIONS
  //$_SESSION['usu_nome']      = $nome;
  //$_SESSION['usu_senha']     = $senha;
  //$_SESSION['usu_setor']     = $nivel;
  // $login = $_SESSION['usu_login'];
  $id_usuario = $_SESSION['usu_id'];
  $loja       = $_SESSION['usu_loja_id'];
  $quest      = $_SESSION['quest'];
?>
<?php
 $query_count = mysql_query("SELECT
       COUNT(rp.id)  AS TOTAL_PERG
           FROM
              relacaoperg AS rp
                                INNER JOIN perguntas AS p   ON rp.id_pergunta = p.perg_id
                                INNER JOIN area      AS a   ON rp.id_area     = a.area_id
                                INNER JOIN sub_area  AS sb  ON rp.id_subgrupo = sb.sub_area_cod
                                WHERE
                                    a.area_id='1' AND sb.sub_area_cod='1'")or die(mysql_error());
    while ($row = mysql_fetch_array($query_count)) {
    $totalpergunta  = $row["TOTAL_PERG"];
    }
    ?>
    <?php
    $pergunta=1;
    while( $pergunta <= $totalpergunta ){
     $query_pesquisa = mysql_query("SELECT
       rp.id            AS ORDEM,
       a.area_id        AS AREA,
       sb.sub_area_cod  AS SUBGRUPO,
       sb.sub_area_nome AS DESC_SUBGRUPO,
       p.perg_id        AS ID_PEGUNTA,
       p.perg_desc      AS DESC_PERGUNTA,
       rp.foto          AS FOTO
           FROM
              relacaoperg AS rp
                                INNER JOIN perguntas AS p   ON rp.id_pergunta = p.perg_id
                                INNER JOIN area      AS a   ON rp.id_area     = a.area_id
                                INNER JOIN sub_area  AS sb  ON rp.id_subgrupo = sb.sub_area_cod

                                WHERE
                                    a.area_id='1' AND sb.sub_area_cod='1' AND rp.id='$pergunta' ")or die(mysql_error());

    if (empty($query_pesquisa)) {
    echo "Nenhum registro encontrado.";
    }
    while ($row = mysql_fetch_array($query_pesquisa)) {
    $ordem          = $row["ORDEM"];
    $area           = $row["AREA"];
    $subgrupo       = $row["SUBGRUPO"];
    $descsubgrupo   = $row["DESC_SUBGRUPO"];
    $idpergunta     = $row["ID_PEGUNTA"];
    $descpergunta   = $row["DESC_PERGUNTA"];
    $foto           = $row["FOTO"];
    }
    ?>
<br>
<div class="container">
<div id="div1" style="width:80%; margin:5 auto;">
      <center><div class="panel panel-danger"><div class="panel-heading"><?php echo"$descsubgrupo";?></div></div></center>
<div class="jumbotron">

 <form class="form-horizontal" action="index.php" method="GET">
  <fieldset>
    <legend>Pergunta <?php echo"$ordem";?>/<?php echo"$totalpergunta";?></legend>
    <div class="form-group">
      <h3><label><?php echo"$descpergunta";?></label></h3>
      <div class="col-lg-10">
        <div class="radio">
          <label>
            <input type="radio" name="optionsRadios" id="optionsRadios1" value="5">
            OTIMO
          </label>
        </div>
        <div class="radio">
          <label>
            <input type="radio" name="optionsRadios" id="optionsRadios1" value="3">
            REGULAR
          </label>
        </div>
        <div class="radio">
          <label>
            <input type="radio" name="optionsRadios" id="optionsRadios1" value="1">
            RUIM
          </label>
        </div>
        <div class="radio">
          <label>
            <input type="radio" name="optionsRadios" id="optionsRadios2" value="0">
            NAO APLICADO
          </label>
        </div>
    </div>

   <br />
<?php
 $query_resp = mysql_query("SELECT *
     FROM
        respostas
             WHERE
               resp_usuario='$id_usuario'
                 AND resp_questionario='$quest'
                 AND resp_area='$area'
                 AND resp_subgrupo='$subgrupo'
                 AND resp_loja='$loja'
                 AND resp_pergunta_id='$idpergunta'")or die(mysql_error());
    while ($row = mysql_fetch_array($query_resp)) {
    $resposta   = $row['resp_resposta'];
    $st         = $row['resp_status'];
     }
    echo"<div class'form-group'>";
    echo"<div class='col-lg-10 col-lg-offset-2'>";
    $status=$st;
     if ($status == "1") {
        echo"<center><h4>PERGUNTA JA RESPONDIDA | RESPOSTA:$resposta</h4></center>";
     } else {
        echo"<center><button  type='submit' class='btn btn-danger'>REPONDER</button></center><br />";
       }
        echo"</div>";
     echo"</div>";
      var_dump($query_resp);

?>
  </fieldset>

 </form>
</div>
</div>
</div>


</body>
</html>
<?php $pergunta++; } ?>