Грешка при последни теми от форума

[Zoomchoo]

Слагам следния код :

<?

$user="root";
$pass="******";
$db="forum";
$broi_temi="10";// Колко последни теми да показва
$broi_bukvi="35";//До колко букви от заглавието на темата да показва
mysql_connect(localhost,$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT topic_time , topic_title,forum_id,topic_id, topic_replies,topic_type from phpbb_topics ORDER BY topic_time ";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();

$ii=$num-$broi_temi;
for ($i=$num-1; $i>$ii;$i--)
{
$tema=mysql_result($result,$i,"topic_title");
$id=mysql_result($result,$i,"forum_id");
$topic_broi=mysql_result($result,$i,"topic_replies");
$topic_id=mysql_result($result,$i,"topic_id");
$topic=mysql_result($result,$i,"topic_type");

if($topic=="1")
{$vazna='Важна:';}
elseif($topic=="2")
{$vazna='Съобщение:';}
elseif($topic_status=="1")
{$vazna='Заключена:';}
else
{$vazna='';}

if (strlen($tema)>$broi_bukvi)
{$totchki='...';}
else
{$totchki='';}

$tema=substr($tema,0 , $broi_bukvi);
echo" $vazna<a href='http://127.0.0.1/forum/viewtopic.php?t=$topic_id' >$tema$totchki ($topic_broi)</a><br/>";
}


?>

и ми дава този ерор

$ii;$i--) { $tema=mysql_result($result,$i,"topic_title"); $id=mysql_result($result,$i,"forum_id"); $topic_broi=mysql_result($result,$i,"topic_replies"); $topic_id=mysql_result($result,$i,"topic_id"); $topic=mysql_result($result,$i,"topic_type"); if($topic=="1") {$vazna='Важна:';} elseif($topic=="2") {$vazna='Съобщение:';} elseif($topic_status=="1") {$vazna='Заключена:';} else {$vazna='';} if (strlen($tema)>$broi_bukvi) {$totchki='...';} else {$totchki='';} $tema=substr($tema,0 , $broi_bukvi); echo" $vazna$tema$totchki ($topic_broi)
"; } ?>

Използвам phpbb2

 

[Lasevg]

<?php

$user="root";
$pass="******";
$db="forum";
$broi_temi="10";// Колко последни теми да показва
$broi_bukvi="35";//До колко букви от заглавието на темата да показва
mysql_connect(localhost,$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT topic_time , topic_title,forum_id,topic_id, topic_replies,topic_type from phpbb_topics ORDER BY topic_time ";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();

$ii=$num-$broi_temi;
for ($i=$num-1; $i>$ii;$i--)
{
$tema=mysql_result($result,$i,"topic_title");
$id=mysql_result($result,$i,"forum_id");
$topic_broi=mysql_result($result,$i,"topic_replies");
$topic_id=mysql_result($result,$i,"topic_id");
$topic=mysql_result($result,$i,"topic_type");

if($topic=="1")
{$vazna='Важна:';}
elseif($topic=="2")
{$vazna='Съобщение:';}
elseif($topic_status=="1")
{$vazna='Заключена:';}
else
{$vazna='';}

if (strlen($tema)>$broi_bukvi)
{$totchki='...';}
else
{$totchki='';}

$tema=substr($tema,0 , $broi_bukvi);
echo" $vazna<a href='http://127.0.0.1/forum/viewtopic.php?t=$topic_id' >$tema$totchki ($topic_broi)</a><br/>";
}


?>

Пробвай така

 

[Zoomchoo]

и ми дава така:

asdas (1)
asdasda (0)
Welcome to phpBB 2 (0)

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 12 in C:\xampp\htdocs\index.php on line 190

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 12 in C:\xampp\htdocs\index.php on line 191

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 12 in C:\xampp\htdocs\index.php on line 192

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 12 in C:\xampp\htdocs\index.php on line 193

Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 12 in C:\xampp\htdocs\index.php on line 194
()

 

[Stefan Salvatore]

190
191
192
193
194

Трябва да ги изтриеш