MySQL - select

<table style="width:100%">

  <tr>

    <th>Cafe</th>

    <th>Yerba</th>

    <th>Azucar</th>

    <th>Té</th>

  </tr>

  <tr>

    <td>1000</td>

    <td>500</td>

    <td>700</td>

    <td>1020</td>

  </tr>

</table>

<?php

	$server = "localhost";

	$userName = "root";

	$Password = "tupassword";

	$db = "mibasededatos";

	$conex = mysqli_connect($server,$userName,$Password,$db);

	$sql = "SELECT * FROM detallefactura";

	$query = mysqli_query($conn,$sql);

?>

<table style="width:100%">

  <tr>

    <th>Cafe</th>

    <th>Yerba</th>

    <th>Azucar</th>

    <th>Té</th>

  </tr>

<?php

while($fila=mysqli_fetch_array($query,MYSQLI_ASSOC))

{

?>

  <tr>

    <td><?php echo $fila["precio_cafe"];?></td>

    <td><?php echo $fila["precio_yerba"];?></td>

    <td><?php echo $fila["precio_azucar"];?></td>

    <td><?php echo $fila["precio_te"];?></td>

    <td>1020</td>

  </tr>

<?php

}

?>

</table>

<?php

mysqli_close($conex);

?>