Sorry this is so late. I've been having a lot of trouble lately.
Okay, here's the code using the DATE_FORMAT function. I have posted only the code that is having trouble, because the forum was saying my post was too long.
When coded this way, it displays the date just fine:
<?php
// DISPLAYING ENTRIES NOW
while ($obj = $result1->fetch_object())
{
echo "<div class='news'><a href='show_news.php/" . $obj->post_id . "/" . $obj->title . "'>" . strip_tags($obj->title, '<p><br><a><b><i>') . "</a></div>";
echo "<div class='news'><b>Posted by:</b> " . strip_tags($obj->author_name, '<p><br><a><b><i>') . " in " . strip_tags($obj->category_name, '<p><br><a><b><i>') . "</div>";
echo "<div class='news'><b>" . $obj->formatted_date . "</b></div>";
echo "<div class='news_post'>" . BBCODE(truncate(strip_tags($obj->post_body, '<p><br><a><b><i>'))) . "</div>"; }
echo "<br><br>";
// now, display the pages
for ($counter = $first_page; $counter <= $last_page; $counter++)
{
if ($counter == $page_number)
{
echo $counter;
}
else
{
echo "<a href='test_copy.php?page_number=$counter'>$counter</a>";
}
}
$result1->close(); } else { printf("Result Error %s\n", $conn->error); } $conn->close();
?>
</div>
</div>
</div>
</div>
</body>
</html>
And here, without DATE_FORMAT(), the date doesn't display at all.
<?php
// DISPLAYING ENTRIES NOW
while ($obj = $result1->fetch_object())
{
echo "<div class='news'><a href='show_news.php/" . $obj->post_id . "/" . $obj->title . "'>" . strip_tags($obj->title, '<p><br><a><b><i>') . "</a></div>";
echo "<div class='news'><b>Posted by:</b> " . strip_tags($obj->author_name, '<p><br><a><b><i>') . " in " . strip_tags($obj->category_name, '<p><br><a><b><i>') . "</div>";
echo "<div class='news'><b>" . $obj->date_posted . "</b></div>";
echo "<div class='news_post'>" . BBCODE(truncate(strip_tags($obj->post_body, '<p><br><a><b><i>'))) . "</div>"; }
echo "<br><br>";
// now, display the pages
for ($counter = $first_page; $counter <= $last_page; $counter++)
{
if ($counter == $page_number)
{
echo $counter;
}
else
{
echo "<a href='test_copy.php?page_number=$counter'>$counter</a>";
}
}
$result1->close(); } else { printf("Result Error %s\n", $conn->error); } $conn->close();
?>
</div>
</div>
</div>
</div>
</body>
</html>