Hi would like to display in an IFRAME (located in a non-vB page) the content of a .php file. This php file would contain a query to the database, to retrieve the latest 10 posts from the forum number 29.

Can you help for what concerns the php file, please?

Thank you very much :o

<script language="php">
require("includes/config.php");
$servername = $config['MasterServer']['servername'];
$dbusername = $config['MasterServer']['username'];
$dbpassword = $config['MasterServer']['password'];
$dbname = $config['Database']['dbname'];
$db = mysql_connect($servername,$dbusername,$dbpassword) or die("Can't open connection to MySQL");
mysql_select_db($dbname) or die("Can't select database");
$query = mysql_query("SELECT * FROM thread WHERE visible=1 AND forumid =29 ORDER BY lastpost DESC LIMIT 10");
$last = "document.write(\"<marquee onmouseover=this.stop() onmouseout=this.start() dir='rtl' direction='right' scrollAmount='3' scrolldelay='20'>";
while($thread = mysql_fetch_array($query)){
$last .= "<a href='showthread.php?goto=lastpost&t=$thread[threadid]' title='Last post by $thread[lastposter]' target='_blank'><font color='navy'>$thread[title]</font></a>&nbsp;&nbsp;&nbsp;&nbsp;<font color='#448CCB'>¤¤</font>&nbsp;&nbsp;&nbsp;&nbsp;";
}
$last .= "</marquee>\");";
mysql_close($db);
echo $last;</script>



put the prevous code in file last.php

in the non-vb page put

<script type="text/javascript" src="PATH_TO_/last.php"></script>



this is for vb3.5

Hi, I was wrong, the page is a vB template, not a non-vB page.

Can you help?

up

Please help... I don't really know what to do :(



I even tried the code you posted creating a non-vB page, but that doesn't work anyway.

Heeeelpppp :'(