Hello!
I want create other pages .php with recent posts in .html format
I try this code:
The result must be as this! Link<?php
echo " <table width=\"100%\" border=\"1\"> <tr>
<td height=\"15\" class=\"tabella\"><span class=testotitolo>Ultime dal Nostro Forum</span></td>
<td height=\"15\" class=\"tabella\"><span class=testotitolo>Autore</span></td>
<td height=\"15\" class=\"tabella\"><span class=testotitolo>Risposte</span></td>
<td height=\"15\" class=\"tabella\"><span class=testotitolo>Visite</span></td>
</tr> ";
include_once ('forums/includes/functions_vbseo.php');
vbseo_get_options();
vbseo_prepare_seo_replace();
get_forum_info();
mysql_pconnect("host", "user","pass") or die("Ci Scusiamo Per l'incoveniente tornero on-line tra 10 minuti");
mysql_select_db("tuodatabse") or die("Impossibile selezionare il database");
$query = "SELECT * FROM VB_thread WHERE forumid=1 ORDER BY threadid DESC LIMIT 20";
$risultati= mysql_query($query);
$conta=0;
while($tmp = mysql_fetch_assoc($risultati))
{
$threadrow = $tmp;
$conta++;
$target1=$tmp["title"];
$replycount=$tmp["replycount"];
$postusername=$tmp["postusername"];
$postuserid=$tmp["postuserid"];
$lastposter=$tmp["lastposter"];
$views=$tmp["views"];
$valutazione=$tmp["votetotal"];
if($start>=0){
$threadurl = vbseo_thread_url_row($threadrow, $start);
}else{
$threadurl = vbseo_thread_url_row($threadrow);
}
$getprofile = mysql_query("SELECT * FROM VB_user WHERE userid =".$postuserid);
$conta=0;
while($tmp = mysql_fetch_assoc($getprofile))
{
$profilerow = $tmp;
$conta++;
}
$profileurl = "members/".$profilerow['username'].".html";
$profileurl = strtolower($profileurl);
echo"<tr><td align=\"left\"><a href=\"http://www.sito.it/forums/$threadurl\">$target1</a> </td><td> <b>$postusername</b> </td><td > <b>$replycount</b> </td><td > <b>$views</b></td><tr>";
}
echo " </table><br>";
But on my site it's don't work : Link
Please, Where is the error?
Sorry for my bad english
Thanks friends![]()



LinkBack URL
About LinkBacks







Reply With Quote