Print two columns array into HTML table

Question

I have the following Query that I have to display in a HTML table:

$query= "SELECT SUM(amount_pln) AS suma,country FROM fin_revenues GROUP BY country ORDER BY suma DESC";
$result = mysqli_query($mysqli,$query);

When running the query in PHPMYADMIN, it works perfectly as I need but I can't figure out how to get the same result on a html table.

That's how is displayed in phpmyadmin:

Any help will be much appreciated.

Shaunak Shukla · Accepted Answer · 2014-09-15 10:05:27Z

1

    $query= "SELECT SUM(amount_pln) AS suma,country FROM fin_revenues GROUP BY country ORDER BY suma DESC";
    $result = mysqli_query($mysqli,$query);

    echo "<table><tr><td>SUMA</td><td>country</td></tr>";

    while($row = mysqli_fetch_assoc($result)){
    echo "<tr><td>".$row['suma']."</td><td>".$row['country']."</td></tr>";
    }
echo "</table>";
mysqli_free_result($result);

edited Sep 15, 2014 at 10:05

answered Sep 15, 2014 at 9:54

Shaunak Shukla

2,3472 gold badges19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2952715 Over a year ago

Thanks, so far I get only the titles SUMA & country

Shaunak Shukla Over a year ago

@user2952715, I've updated my answer.. Is there any error you getting?

Ram Sharma Over a year ago

Both the answer looks similar, if your answer was first and correct than why other people post same answer again. up vote from my side for your answer

Jenz · Accepted Answer · 2014-09-15 10:15:10Z

1

$query= "SELECT SUM(amount_pln) AS suma,country FROM fin_revenues GROUP BY country ORDER BY suma DESC";
$result = mysqli_query($mysqli,$query);
echo '<table>
        <tr>
          <td>Suma</td>
          <td>Country></td>
       </tr>';
while($row=mysqli_fetch_array($mysqli,$result))   // while there are records
{
    echo "<tr><td>".$row['suma']."</td><td>".$row['country']."</td></tr>";   // echo the table with query results
}
echo '</table';

edited Sep 15, 2014 at 10:15

answered Sep 15, 2014 at 9:53

Jenz

8,3718 gold badges50 silver badges83 bronze badges

1 Comment

user2952715 Over a year ago

I get an error in the following line, seems because of the single quotes echo "<tr><td>$row['suma']</td><td>$row['country']</td></tr>";

Collectives™ on Stack Overflow

Print two columns array into HTML table

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related