<?php
$con=mysqli_connect("xxxxx","xxxxx","xxxxxx","xxxxx");
// Check connection
if (mysqli_connect_errno()) {
echo "Nu s-a putut realiza conectiunea cu baza de date MySQL: " . mysqli_connect_error();
}
$imobilizari_corporale = mysqli_query($con,"SELECT SUM(suma) AS `total_imob_corporale` FROM `2014` WHERE subcat='imobilizari_corporale'");
$credite_tl = mysqli_query($con,"SELECT SUM(suma) AS `total_credite_tl` FROM `2014` WHERE subcat='credite_tl'");
$HTML = "<table>";
while($row = mysqli_fetch_array($imobilizari_corporale)) <-- !!As vrea sa adaug aici mai multe variabile (cu ar fi $credite_tl).Nu merge prin simpla adaugare cu virgula.
{
$HTML .= <<<HTML
<tr>
<td>Imobilizari Corporale</td>
<td>{$row['total_imob_corporale']}</td>
<td>{$row['total_credite_tl']}</td>
</tr>
HTML;
}
$HTML .= "</table>";
echo $HTML;
mysqli_close($con);
?>
Ma poate ajuta cineva?