Page 1 of 1

Text structure and Date alterations

Posted: Sun Jun 01, 2003 7:11 pm
by Gappa
Ok this is what I have at the moment:

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>
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?