Date formatting

[Tjorriemorrie]

Hey, I have a table Comments and a recordset rsComments for that table. I want to show the comment with the date it was submitted.

 

  <?php do { ?>
    <p class="commenter"><?php echo $row_rsComments['name']; ?> said: <span class="CommentDate"><?php echo " (on ".date("d M y", $row_rsComments['CommentDate']).")"; ?></span></p>
    <p class="commentleft"><?php echo $row_rsComments['comment']; ?></p>
    <p> </p>
    <?php } while ($row_rsComments = mysql_fetch_assoc($rsComments)); ?>

 

Somehow when I test it it always returns 1 Jan 1970. Please take note I'm not familiar with php date() function

 

PS: the CommentDate field is timestamp in MySQL, is that ok?

 

The value lookin in phpMyAdmin shows 2008-03-24 21:16:20. Can anyone help me with this?

[rhodesa]

I think you are looking for:

 

<?php while ($row_rsComments = mysql_fetch_assoc($rsComments)) { ?>
<p class="commenter"><?php echo $row_rsComments['name']; ?> said: <span class="CommentDate"><?php echo " (on ".date("d M y", strtotime($row_rsComments['CommentDate'])).")"; ?></span></p>
<p class="commentleft"><?php echo $row_rsComments['comment']; ?></p>
<p> </p>
<?php } ?>