Smirnoff каза:Дай кода.
><?
$dbhost = 'немамсипредстава';
$db = 'базаданни';
$user = 'име';
$pass = 'парола?!';
$broi="5"; //Колко потребителя да покаже
echo "Топ $broi. потребителя <br/>";
mysql_connect($dbhost,$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT username , user_posts from phpbb_users ORDER BY user_posts ";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
$ii=$num-$broi;
for ($i=$num-1; $i>$ii;$i--)
{
$username=mysql_result($result,$i,"username");
$post=mysql_result($result,$i,"user_posts");
echo "$username-<b>".$post."</b> мнения <br/>";
}
?>
<?
$dbhost = 'немамсипредстава';
$db = 'базаданни';
$user = 'име';
$pass = 'парола?!';
$broi="5"; //Колко потребителя да покаже
echo "Топ $broi. потребителя <br/>";
mysql_connect($dbhost,$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT username , user_posts from phpbb_users ORDER BY user_posts DESC LIMIT 0,'$broi' ";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
$i=0;
while ($i < $num) {
$username=mysql_result($result,$i,"username");
$post=mysql_result($result,$i,"user_posts");
echo "$username-<b>".$post."</b> мнения <br/>";
}
?>
:SWarning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/bukhum6.freehostia.com/sait/index.php on line 101
<?
$dbhost = 'немамсипредстава';
$db = 'базаданни';
$user = 'име';
$pass = 'парола?!';
$broi="5"; //Колко потребителя да покаже
echo "Топ $broi. потребителя <br/>";
mysql_connect($dbhost,$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT username , user_posts from phpbb_users ORDER BY user_posts ";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
$ii=$num-$broi;
for ($i=$num-1; $i>$ii;$i--)
{
$username=mysql_result($result,$i,"username");
$post=mysql_result($result,$i,"user_posts");
echo "$username-<b>".$post."</b> мнения <br/>";
}
?>
<?
$dbhost = 'немамсипредстава';
$db = 'базаданни';
$user = 'име';
$pass = 'парола?!';
$broi="5"; //Колко потребителя да покаже
echo "Топ $broi. потребителя <br/>";
mysql_connect($dbhost,$user,$pass);
mysql_select_db($db) or die( "Unable to select database");
$query="SELECT username , user_posts from phpbb_users ORDER BY user_posts DESC LIMIT 0,$broi ";
$result=mysql_query($query);
mysql_close();
while ($sql = mysql_fetch_object($result))
{
$user = $sql -> username;
$post = $sql -> user_posts;
echo $user."-<b>".$post."</b> мнения <br/>";
}
?>