What mistake am I making when I put the third "address" item in the code

Question

<?php   
        include"conectar.php";



        /// codigo para fazer leitura do banco de dados
        /// incluindo ?php echo $cpf ? entre <> na tabela onde ficará o registro



$query="select nome, cpf from associados ";
$stmt=mysqli_query($con,$query);
if($stmt) {

     $today = date("d.m.y");
} else {
     mysqli_rollback($con);
     echo "Transaction rolled back.<br />";
}


while($row=mysqli_fetch_array($stmt) )
{   
                  $cpf = $row['cpf'];
                  $nome = $row['nome'];
                    **$endereco = $row['endereco'];**

}


mysqli_close($con);          
        ?>


onde insiro o resultado da pesquisa
----------------------------------


 <tr>
                    <td> <?php echo $cpf ?> </td>
                    <td><?php echo $nome ?></td>
                    <td><?php echo $endereco ?></td></td>
</tr>

Answer 1

Missing select the column endereco in the query:

$query="select nome, cpf from associados ";

Seria:

$query="select nome, cpf, endereco from associados";