rendered paste body<?php
date_default_timezone_set('UTC');
if (!mysql_select_db("b7_477360_tales")) {
echo "Unable to select mydbname: " . mysql_error();
exit;
}
$sql = "SELECT *
FROM tales_news
ORDER BY id DESC";
$result = mysql_query($sql);
if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}
while ($row = mysql_fetch_assoc($result)) {
echo "<div class='postbox'>".
"<div class='top_post'>".
"<div class='top_post_avatar'>".
"<img src='images/".$row['poster'].".jpg' width='48' height='48' border='1'>".
"</div>".
"<div class='top_post_display'>".
"<b><span style='color: #db5f1b;'>".$row['title']."</span></b> by <b>".$row['poster']."</b>, ".date("F j Y, g:i a",$row['date']).
"</div></div><div class='post_body'>".$row['text']."</div></div><br/>";
}
?>