While not loading records

Question

While not loading records

Navigation

#1 by (0 votes)
#2 by (0 votes)

2

I'm trying to repeat a region however, although mysqli_num_rows indicates that it has 9 records, in the while nothing is coming. My code looks like this:

        $qry = "SELECT 
        pe_orclinhas.id_orclinha, 
        pe_orcgrupos.grupo_orcamento, 
        pe_orclinhas.dc, 
        pe_orclinhas.orclinha
        FROM pe_orcgrupos 
        INNER JOIN pe_orclinhas ON pe_orcgrupos.id_orca = pe_orclinhas.orcgrupo
        WHERE id_orclinha = $linhab";
        $consulta   = mysqli_query($MySQLi,$qry);
        $registros  = mysqli_num_rows($consulta);

        while($registro = mysqli_fetch_array($consulta)){

        $grp        = $registro[0];
        $tp         = $registro[1];
        $descr      = $registro[2];

    ?>
    <br />
    <em style='color: #003300;'><?php echo $grp; ?></em>
   <?php
   } 
   ?>

while mysqli

asked by anonymous 20.04.2018 / 15:07

2 answers

How to open the sales editor, shopping from VBA in authoring mode Comparison between dates in PHP [duplicate]

score 0 · Answer 1

Try it out:

 <?php
    $qry = "SELECT 
    pe_orclinhas.id_orclinha, 
    pe_orcgrupos.grupo_orcamento, 
    pe_orclinhas.dc, 
    pe_orclinhas.orclinha
    FROM pe_orcgrupos 
    INNER JOIN pe_orclinhas ON pe_orcgrupos.id_orca = pe_orclinhas.orcgrupo
    WHERE id_orclinha = $linhab";
    $consulta   = mysqli_query($MySQLi,$qry);
    $registros  = mysqli_num_rows($consulta);

    while($registro = mysqli_fetch_array($consulta)){

      $grp        = $registro[0];
      $tp         = $registro[1];
      $descr      = $registro[2];

      echo "<br />"
      echo "<em style='color: #003300;'><" . $grp . "></em>"

    } ?>

score 0 · Answer 2

Instead of numbers, enter the name of the column within the index of the arrays:

while($registro = mysqli_fetch_array($consulta)){

    $grp        = $registro['ColunaA'];
    $tp         = $registro['ColunaB'];
    $descr      = $registro['ColunaC'];

?>
<br />
<em style='color: #003300;'><?php echo $grp; ?></em>