How do i display all the data of a user?

[Andreycon]

I want to fetch data from a table let's say  table "activities". 

Uid | day | activity | time | remarks

1.     Mon.    Act1.      3pm.    Good

2.    Mon.     Act1.      5pm.     Bad

1.    Tue.      Act2.      12am.   Bad

1.   Tue.       Act5.      1am.     Bad

1.   Thur.     Act8.       9pm.    Good 

2.   Wed.     Act4.      7am.     Good

 

Now assuming I want to fetch all the data that is related to user Id 1 and display them in another table (Uid 1).  

Which is 4 rows according to the table, how do I go about it using select query?   Thanks!!!

I tried something like this but it displays just one row

<?php

$uid = $_SESSION['login'];

$sql2 = "SELECT * FROM Activities WHERE uid=? ORDER BY Uid LIMIT 6";
$stmt2 = $connection->prepare($sql2); 
$stmt2->bind_param('i', $Uid);
$stmt2->execute();
$result2 = $stmt2->get_result();
$row2 = $result2->fetch_assoc();

//now am stuck here
 ?>

now trying to display the fetch those data for only Uid 1 in these simple format...

 

<table style="width:100%">
  <tr>
    <th>Day</th>
    <th>Activity</th>
    <th>Remarks</th>
  </tr>
  <tr>
    <td>Mon</td>
    <td>Act1</td>
    <td>Good</td>
  </tr>
  <tr>
    <td>Tue</td>
    <td>Act2</td>
    <td>Bad</td>
  </tr>

<tr>
    <td>Tue</td>
    <td>Act5</td>
    <td>Bad</td>
  </tr>
</table>

   Jus like that, to contain all the 4 data for Uid 1. Thanks in advance..

 

 

 

[requinix]

If you want to display more than one thing then you're going to need a loop: fetch a row from the result, display the row, fetch another row, display it, and so on until you run out of rows.

[Andreycon]

Tanx sir