Hi,

I have searched on the internet and here. I have been unable to find a script/code which can display latest discussions on my homepage which is not wordpress a wordpress site.

help much appreciated.

dave

[@johnhiler Member 15 years, 6 months ago]

Your bbpress should have an rss feed. You can turn any rss feed into a widget that you can put on any site… here’s one example:

http://www.technobuzz.net/convert-rss-feed-into-a-widget-with-feedflash/

[@niravdave Member 15 years, 6 months ago]

Hi John,

Thanks for the input. I am already aware about this.

I was looking for another solution. I tried my hands on this code but it doesnt work.

Can some1 help me on this?

help much appreciated.

<?

mysql_connect(“localhost”, “username_db_forum”, “password”);

mysql_select_db(“database_name_forum”);

$sql=”SELECT * FROM bb_posts WHERE post_topic=” ORDER BY post_id DESC LIMIT 8″;

$risultati=mysql_query($sql);

while($riga=mysql_fetch_array($risultati)) {

$target=$riga[“post_topic”];

$target1=$riga[“post_id”];

echo”<img src=”images/bullet.gif” align=”absmiddle”>$target

“;

}

?>

[@atsutane Member 15 years, 6 months ago]

$sql="SELECT * FROM bb_posts WHERE post_topic='' ORDER BY post_id DESC LIMIT 8";

It seem like you telling the script to look for post with empty topic. Try change it to this:

$sql="SELECT * FROM bb_posts ORDER BY post_id DESC LIMIT 8";