How do I display a database table in HTML table dynamically?

Asked Jul 11 '19 at 06:24

Active Jul 11 '19 at 06:33

Viewed 75 times

I want to display the following database table in an HTML table with outlet_name as rows and compet_product_name as columns. I, however, do not want the compet_product_name to repeat themselves. They should be distinct.

https://i.stack.imgur.com/o8oKj.png

edited Jul 11 '19 at 06:33

SAVe

asked Jul 11 '19 at 06:24

davidkihara

Please show you HTML and Database table With code – SAVe Jul 11 '19 at 06:29
The database table is in the link provided – davidkihara Jul 11 '19 at 06:30
1

Hi & welcome to the SO. Please read this first [How to ask a question](https://stackoverflow.com/help/how-to-ask) and also this [How to create a Minimal, Complete, and Verifiable example](https://stackoverflow.com/help/mcve) – Igor Ilic Jul 11 '19 at 06:33
2

Possible duplicate of [MySQL pivot table](https://stackoverflow.com/questions/7674786/mysql-pivot-table) – Igor Ilic Jul 11 '19 at 06:34
Thanks. This will help me get a working solution – davidkihara Jul 11 '19 at 06:49

How do I display a database table in HTML table dynamically?

0 Answers0