I create a table to show the data from my database. I want to add a row even there is no value from database. As you can see to my sample it only show Monday to Friday because their is a data in it from the db. I want to show saturday and sunday as well. I have tried MySQL ADDDATE() and PHP date\_add(). But it only move my date according to the interval i add.

Here is my code in sql:

```
select str_to_date(date,"%Y-%m-%d") as time_stamp, min(time), max(time), 
from attendance;

```

Code in php:

```
<td><?php echo  $list->time_stamp ?>, <?php echo date('D', strtotime($list->time_stamp)) ;?></td>
<td><?php echo  substr($list->m_time, 0,5)?></td>
<td><?php echo  substr($list->mx_time, 0,5)?></td>

```

and here is my output:

![enter image description here](https://i.stack.imgur.com/dXBCh.png)

or could i use php to show monday to sunday? Thanks!