每个php都会导致列中的表而不是行

Question

I have some mysql data like these:

----------------------------------------------------------
| **nomrub** | **nomsousrub** | **datefact** | **qtvol** |
----------------------------------------------------------
|  comm      |    sms         |2016-09-05    |     18    |
|  comm      |    appel       |2016-09-05    |     2h30  |
|  comm      |    data        |2015-09-05    |     550   |
----------------------------------------------------------

etc etc etc..

I need to create a table with the differents date by column like that:

   Date | 2016-09-05 | 2016-09-04 | 2016-09-03 | 2016-09-02 |
   Sms  |  18        |   57       |    652     |   458      |
   Appel|  2h30      |   5h10     |   55h20    |    32h52   |

I'm so stuck because I need to sort result by date and by column but in Html we can't create a table by column, only by row..

I don't want to have one query by cell ..

If anyone can help me ?

Answer 1

You have to alter your mysql table for that

Query : ALTER TABLE <yourtable> ADD <fieldname> VARCHAR(20)

But this is not a proper way to proceed because there is a limit for mysql column size.