Static Pages with vSeo url

Hello!

I want create other pages .php with recent posts in .html format
I try this code:

<?php
echo " <table width=\"100&#37;\" 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>";

The result must be as this! Link

But on my site it's don't work : Link

Please, Where is the error?

Sorry for my bad english

Thanks friends

Hello,

is this forum id correct ?

PHP Code:

$query = "SELECT * FROM VB_thread WHERE forumid=1 ORDER BY threadid DESC LIMIT 20"; 


Hi Oleg!

Pardon, I have change that string in:

$query = "SELECT * FROM VB_thread WHERE forumid=12 ORDER BY threadid DESC LIMIT 20";

12 = Software Freeware

But...Nada

The problem doesn't seem to be related to vBSEO in this case - your sql query doesn't return any thread rows, you could try to execute this query in phpmyadmin or vB admincp to check it further.

Mmm okey Oleg, I try to execute query in phpmyadmin

Very thanks for your kind ;-)

Bye!