title: mysqli return data in multiple rows with same id
body: <p>hello so here is what I have in a table called "members"</p>
  
  <pre><code>id - key - value
  1    name  john
  1    age   35
  1    zip   12345
  2    name  stacy
  2    age   22
  2    zip   11223
  3    name  mark
  3    age   44 
  3    ssn   11111111
  3    zip   54321
  </code></pre>
  
  <p>I am trying to return this data in this manner: </p>
  
  <pre><code>1 - john - 35 - 12345
  2 - stacey - 22- 11223
  etc... (its a longer list)
  </code></pre>
  
  <p>I need it in this format that way I can insert it into another table using a loop.
  any ideas on how I can do that ? </p>
  
  <pre><code>$resultat = mysqli_query($con,"SELECT * FROM members'");
  </code></pre>
  
  <p>this will get all members. I am not sure how to go about doing what i need 
  any input would be greatly appreciated thank you !!</p>