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.
Asked
Active
Viewed 78 times
0
-
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
-
1Hi & 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
-
2Possible 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