Text structure and Date alterations
Posted: Sun Jun 01, 2003 7:11 pm
Ok this is what I have at the moment:
Ok, so what the above basically does accesses a database which is also used for a phpBB forum and makes part of the forum like a news script.
What I would like to do I have the date displayed be at GTM +11 times, and make the post body include the "returns" from the post which it is not currently doing. What do I need to do to make this happen?
Code: Select all
<html>
<head>
<title> Rantage.tk :: News ::</title>
</head>
<body bgcolor="#000000">
<table border=0 width=75%>
<?php
$db = mysql_connect("localhost", "Gappa", " ");
mysql_select_db("Gappa",$db);
$query = 'SELECT topic_title, topic_id, FROM_UNIXTIME(topic_time,"%W the %D %M @ %r") AS Topic_Date, post_text, username FROM phpbb_topics RIGHT JOIN phpbb_posts_text ON topic_first_post_id=post_id RIGHT JOIN phpbb_users ON topic_poster=user_id WHERE forum_id=6 ORDER BY topic_time DESC';
$result = mysql_query($query, $db) or die ($query .': '.mysql_error());
while($row = mysql_fetch_assoc($result))
{
echo "<b><FONT FACE=Arial SIZE=-1 COLOR=#FF9900>";
echo "$row[topic_title]:</FONT></b><br/>";
echo "<FONT FACE=Arail SIZE=-2 COLOR=#999999>posted by: <b>$row[username]</b>";
echo " on: ";
echo "$row[Topic_Date]</FONT><br/><br/>";
echo "<FONT FACE=Arail SIZE=-1 COLOR=#FFFFFF> $row[post_text]</FONT>";
echo "<br/><br/>";
echo "<FONT FACE=Arial SIZE=-2>";
echo "<a href="http://www.hostultra.com/~Gappa/phpBB2/viewtopic.php?t=$row[topic_id]"><b><FONT COLOR=#FF9900>Read comments</FONT></b></a></FONT>";
echo "<br/><br/><br/>";
}
?>
</table>
</body>
</html>What I would like to do I have the date displayed be at GTM +11 times, and make the post body include the "returns" from the post which it is not currently doing. What do I need to do to make this happen?