title: grouping based on same columid in mysql php
body: <p>i am working on file uploading project in which file uploading was sucessful. </p>
  
  <p>Now i am looking for displaying my uploads table which is used to store details of uploaded files is like:</p>
  
  <pre><code>+--------------------+--------------------+------------------+-----------+
  |    projectId       |  filename          |  projectDetails  |ProjectName |
  +--------------------+--------------------+------------------+------------+
  |   pid1             | admin.zip          |  This Is A Test  |myProject   |
  |   pid1             | admin1.zip         |  This Is A Test  |myProject   |
  |   pid2             | admin2.zip         |  This Is A Test2 |myProject2  |
  |   pid2             | admin3.zip         |  This Is A Test2 |myProject2  |
  |   pid1             | admin4.zip         |  This Is A Test  |myProject   |
  +--------------------+--------------------+------------------+------------+
  </code></pre>
  
  <p>can i know that can i get an output like</p>
  
  <pre><code> +--------------------+--------------------+------------------+-----------+
  |    projectId       |  filename          |  projectDetails  |ProjectName |
  +--------------------+--------------------+------------------+------------+
  |   pid1             | admin.zip          |  This Is A Test  |myProject   |
  |                    | admin1.zip         |                  |            |
  |                    | admin4.zip         |                  |            |
  +--------------------+--------------------+------------------+------------+
  </code></pre>