<div class="container">
<div style="height:50px;"></div>
<div class="well" style="margin-left:auto; margin-right:auto; padding:auto; width:70%;">
<span style="font-size:25px; color:#1f1a2f"><strong>Sorteio</strong></span> <!-- BOTÕES -->
<span class="pull-right"><a href="#addnewPe" data-toggle="modal" class="btn btn-primary"><span class="glyphicon glyphicon-plus"></span> Adicionar</a></span>
<div style="height:15px;"></div>
<table class="table table-striped table-bordered table-hover">
<thead>
<th>Codigo</th>
<th>Data pedido</th>
<th>Cliente</th>
<th>Funcionário</th>
<th>Produto</th>
<th>Quantidade</th>
<th>Total do pedido</th>
<th>Ação</th>
</thead>
<tbody>
<?php
$query=$conn->query("SELECT * FROM tb_pedido Pp INNER JOIN tb_cliente C ON Pp.codCliente = C.codCliente INNER JOIN tb_funcionario F ON Pp.codFuncionario = F.codFuncionario INNER JOIN tb_produto P ON Pp.codProduto = P.codProduto");
while($row=mysqli_fetch_array($query)){
?>
<tr>
<td><?php echo $row['codPedido']; ?></td>
<td><?php echo $row['dataPedido']; ?></td>
<td><?php echo $row['nomeCliente']; ?></td>
<td><?php echo $row['nomeFuncionario']; ?></td>
<td><?php echo $row['descricao']; ?></td>
<td><?php echo $row['qtdVendida']; ?></td>
<td><?php echo $row['totalPedido']; ?></td>
<td>
<span class="pull-center"><a href="#delPp<?php echo $row['codPedido']; ?>" data-toggle="modal" class="btn btn-danger"><span class="glyphicon glyphicon-trash"></span></a></span>
<p>_____</p>
<span class="pull-center"><a href="#editPp<?php echo $row['codPedido']; ?>" data-toggle="modal" class="btn btn-warning"><span class="glyphicon glyphicon-edit"></span></a></span>
<?php include('pedido/button.php'); ?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
if(isset($_SESSION['msgPp'])){
?>
<div class="alert alert-success">
<?php echo $_SESSION['msgPp']; ?>
</div>
<?php
unset($_SESSION['msgPp']);
}
?>
</div>
<?php include('pedido/add_modal.php'); ?>
it is giving error in the fetch array
Warning: mysqli_fetch_array () expects parameter 1 to be mysqli_result, string given in C: \ wamp \ www \ crud_oop \ index.php on line 233
Thanks in advance for the help! ^^