hi all,
I installed vb 2.5 and wanted to include the file last.php in the header of my vb page.
The last.php file connects to a different database on my site and retrievs the last 7 records on it. The last.php file looks like:
PHP Code:
<?
$dbservertypee="mysql";
$servernamee="localhost";
$dbusernamee="name";
$dbpasswordd="pass";
$dbnamee="db";
$urll="http://www.mysite.com";
$topicss = "7";
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "select * from table1 where catname='general'";
$queryresult = mysql_query($query);
$count = mysql_numrows($queryresult);
$query2 = "select * from table1 where catname='general' order by idnum desc limit 0,$topics";
$queryresult2 = mysql_query($query2);
$count2=mysql_numrows($queryresult2);
if ($count2 == "0") {
echo "No records";
}
else {
while($row = mysql_fetch_object($queryresult2)) {
echo "<tr>
<td width=\"20\" bgcolor=\"#F0F0F0\" align=\"center\">
<img border=\"0\" src=\"http://www.mysite.com/photos/new.gif\" width=\"12\" height=\"10\"></td>
<td bgcolor=\"#F0F0F0\" align=\"right\" onMouseOver=\"this.style.backgroundColor='#fffeff';this.style.cursor='hand';\"
onMouseOut=\"this.style.backgroundColor='#F0F0F0';\"
onClick=\"window.location.href='http://www.mysite.com/index.php?ct=general&md=details&id=$row->idnum'\">
<a href=\"$url/index.php?ct=general&md=details&id=$row->idnum\">$row->title</a></font></td>
<td bgcolor=\"#F0F0F0\" width=\"80\">
<p align=\"center\"><b><font size=\"2\">$row->field01</font></span></b></td>
</tr>
";
}
}
mysql_close();
?>
then I modyfy the phpinlude template as follows:
ob_start();
require("/path/last.php");
$last = ob_get_contents();
ob_end_clean();
this causes a seriuos problem in my forum and error msgs show up even before I put the &last variable in the header!!!
I have been trying to figure out what is going on, but failed to fix it.
Can anyone plz help me with this?! Any help is apreciated
thanx a lot