This script was working, now it is not after my host upgraded MySQL 4.0.13
Can any body see any errors in here??
I really need some help with this, cheers.
<html>
<head>
<title>Rantage.tk :: News</title>
</head>
<body bgcolor="#000000" text="#FFFFFF" link="#6699FF" vlink="#6699FF" alink="#6699FF" topmargin="0" leftmargin="0">
<center>
<table border="0" width="786" height="100" background="rantage.jpg" cellspacing="0" cellpadding="0">
<td width="265" valign="bottom">
<p align="right"><img border="0" src="button1.gif" width="30" height="30"><a href="http://www.hostultra.com/~Gappa/phpBB2/index.php"><img border="0" src="button2.gif" width="30" height="30"></a><a href="http://www.hostultra.com/~Gappa/gallery.php"><img border="0" src="button2.gif" width="30" height="30"></a><a href="http://www.hostultra.com/~Gappa/links.php"><img border="0" src="button2.gif" width="30" height="30"></a>
<td width="521"><FONT FACE=Arial SIZE=-2><script language="JavaScript" type="text/javascript" src="http://www.hostultra.com/~Gappa/phpBB2/topics_anywhere.php?mode=show&f=bKDQsIDEsIDIsIDUp&n=3&r=y&b=lpi&lpb=1&cl=style.css&ct=style.css"></script> </td></table>
<table border="0" width="764">
<?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 "<br/><b><FONT FACE=Arial SIZE=-1 COLOR=#6699FF>";
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/><hr><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=#6699FF>Read comments</FONT></b></a></FONT>";
echo "<br/><br/>";
}
?>
</table>
<table border="0" width="786" height="100" background="footer.jpg" cellspacing="0" cellpadding="0">
<td width="768">
<p align="center"><font face="Arial" size="1">hosted by <a href="http://www.hostultra.com/cgi-bin/ref.cgi?Gappa
">Hostultra</a><br>
message board powered by phpBB 2.0.4</font></td>
</table>
</center>
</body>
</html>
