Jump to content

Grouping Date Not Working


Danny620

Recommended Posts

my code below works fine however the last record has a new header

 

see screenshoot

 

screen.jpg

 

<?php

  $last_date = substr($all_status[0]['dr'], 0, -6);
  $date = substr($all_status[0]['dr'], 0, -6);

  foreach($all_status as $status){ ?>

  <?php

  if($last_date == $date){

	 $date = substr($status['dr'], 0, -6);

	 echo '<tr><th colspan="6" style="text-align:center; background-color:#CBF09E">' .  $date . '';

		   if($last_date == date('F d, Y')){ echo ' - Today'; }

	  echo '</th></tr>';

	 }else{

	 $last_date = substr($status['dr'], 0, -6);

	 }

  ?>

  <?php $status_message = substr(strip_tags($status['status_message'], ''), 0, 44) . '...'; ?>

   <tr>
   <td>...</td>
   <td><?php echo ($status['sent'] == '1') ? '<i class="icon-ok" title="Successfully Sent"></i>' : '<i class="icon-time" title="Not Yet Posted"></i>' ?></td>
   <td><?php echo ($status['success'] == '1') ? '<i class="icon-ok" title="Successfully Posted"></i>' : '<i class="icon-remove" title="Failed To Post"></i>' ?></td>
   <td><?php echo $status_message; ?></td>
   <td><?php echo $status['dr']; ?></td>
   <td>
   <a data-keyboard="true" data-backdrop="true" class="btn small edit" href="#">Edit</a>
   <a class="btn btn-danger" data-keyboard="true" data-backdrop="true" href="<?php echo BASE_LOGGEDIN_URL . 'delete.php?item=3&id=' . $status['status_id'] . ''; ?>">Delete</a></td>
   </tr>

   <?php } ?>

   </tbody>
   </table>

Link to comment
https://forums.phpfreaks.com/topic/271261-grouping-date-not-working/
Share on other sites

Your logic is a little wrong there.

 

$last_date = false;
$date = '';

foreach($all_status as $status){ ?>

<?php
$date = substr($status['dr'], 0, -6);
if($last_date != $date){

 //no reason for this line here
 //$date = substr($status['dr'], 0, -6);

 echo '<tr><th colspan="6" style="text-align:center; background-color:#CBF09E">' . $date . '';

 if($date == date('F d, Y')){ echo ' - Today'; }

 echo '</th></tr>';

 $last_date = $date;
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.