Its working fine, and I get the posts, the only problem is BB code...
say someone posts
Cool.
When I get it out of my database, and put it somewhere, it shows up as
Code: Select all
[b]cool[/b]
HTML it gets stored into the database with < and > while BB code gets put it as regular BB code.
The best solution would probably be some way to decode the BBcode and change it into HTML. Any suggestion?
Current code on testing page:
Code: Select all
<?php
$con = mysql_connect("my host","my username","my password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my DB", $con);
$result = mysql_query("SELECT * FROM phpbb_posts WHERE forum_id='39' ORDER BY post_subject");
while($row = mysql_fetch_array($result))
{
?><font color=#C7C7C7>
<?php
echo $row['post_text'];?>
<br><br>
<img src="/divide.jpg"><br><br>
<?php
}
mysql_close($con);
?>
<img src="/divide.jpg"><br><br> is there to separate the posts, and the font color tag is there to, well, change the font color.
Argg... If only phpBB3 supported HTML...