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

Anton40

Registered
Значи според мен направих всичко както трябва и накрая ми изписва това:

Код:
Parse error: syntax error, unexpected T_DNUMBER in /home/a1312532/public_html/latest.php on line 9

А ето го и кода на latest.php:

Код:
<?
$user="a1312532_toni"; //DB user
$pass="kreten4e140"; //DB pass
$db="a1312532_indigo"; //DB name

$broi_temi="5"; // Колко последни теми да показва
$broi_bukvi="35"; //До колко букви от заглавието на темата да показва

mysql_connect(mysql8.000webhost.com,$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT c.topic_time , c.topic_title,c.forum_id,c.topic_id, c.topic_replies,c.topic_type,f.forum_name FROM phpbb_topics c, phpbb_forums f WHERE c.forum_id=f.forum_id and f.auth_view like '0' ORDER BY c.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,"c.topic_title");
$id=mysql_result($result,$i,"c.forum_id");
$topic_broi=mysql_result($result,$i,"c.topic_replies");
$topic_id=mysql_result($result,$i,"c.topic_id");
$topic=mysql_result($result,$i,"c.topic_type");
$cat=mysql_result($result,$i,"f.forum_name");

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

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


?>
 
Код:
mysql_connect(mysql8.000webhost.com,$user,$pass);
Това го направи по този начин...

Код:
mysql_connect("mysql8.000webhost.com",$user,$pass);
 
Сега ми излезе това:

[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 14: mysql_num_rows(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 21: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 22: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 23: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 24: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 25: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 26: mysql_result(): supplied argument is not a valid MySQL result resource
» : ()
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 21: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 22: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 23: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 24: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 25: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 26: mysql_result(): supplied argument is not a valid MySQL result resource
» : ()
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 21: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 22: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 23: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 24: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 25: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 26: mysql_result(): supplied argument is not a valid MySQL result resource
» : ()
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 21: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 22: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 23: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 24: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 25: mysql_result(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /home/a1312532/public_html/latest.php on line 26: mysql_result(): supplied argument is not a valid MySQL result resource
» : ()
 
Пробвай да махнеш реда дето е mysql_close(); защото ти спираш MySQL и по-надолу пак искаш да използваш mysql.
 
Не става :(
Може ли да ми дадеш скрипт за последни теми от форум phpbb3, който си го пробвал и знаеш че работи добре
 
Ако имах време сега щях аз да ти напиша един, но нямам за това пробвай това

http://web-tourist.net/login/login/view.php?st=2156
 

Back
Горе