Simple displaying DB results gone bad

technical_itch

Before I get to what i'm trying to do, I must mention, this is for a PHPNuke Moudle v7.4. I don't know how many people can help me because of that but if you think you can please help as I am completly lost.

I'm trying to list DB results in a table. The DB name is nuke_team, the feilds are $uname, $gamertag, $team_rank, $team_num, $origin. Username, Gamertag, Rank, Number, Origin.

Warning: Wrong parameter count for mysql_num_rows() in /home/forzawor/public_html/modules/fw_team/index.php on line 14

<?php
if (!eregi("modules.php", $PHP_SELF)){ 
  die ("You can't access this rows directly...");
}
$index = 1; 
require_once("mainfile.php");
$module_name = basename(dirname(__FILE__)); 
get_lang($module_name); 
include("header.php");
OpenTable();
echo "<center><table><tr><td width=100 bgcolor=#EAEAEA>Member</td><td width=100 bgcolor=#EAEAEA>Gamertag</td><td width=100 bgcolor=#EAEAEA>Rank</td><td width=50 bgcolor=#EAEAEA>Number</td><td width=100 bgcolor=#EAEAEA>Origin</td></tr></table> <br>" ; 

$resultpersons = sql_query("SELECT uname gamertag team_rank team_num origin 
     FROM ".$prefix."_team", $dbi); 
  for ($m=0; $m <mysql_num_rows($resultpersons,$res, $dbi); $m++)
  list($uname, $gamertag, $team_rank, $team_num, $origin) = sql_fetch_row(&$res, $nr, $resulpersons, $dbi); 
echo "$uname, $gamertag, $team_rank, $team_num, $origin ";
CloseTable();

See the script in action

Line 14 is for ($m=0; $m <mysql_num_rows($resultpersons,$res, $dbi); $m++)

Any help is greeeaaatly appreciated since this has been driving me nuts

Kudose

[man]mysql_num_rows/man should only have one parameter. That is why you are getting te error. If you click that link it will show you that the only parameter should be the resource link.

i.e.

$db = mysql_connect("localhost", "user", "pass", "database");
$sql_query = mysql_query("SELECT * FROM table", $db);
$num = mysql_num_rows($sql_query);
echo $num;

Hope that helps.

technical_itch

Thanks for your reply Kudose, however I got this to work here. I hate being a newb. Anyways everything displays wonderfully, I know the code to order it by something. What i want to do is, order it by the rank, I basically made another feild called rank_num to each user. That number will be used to order it, the highest rank being 10, and going down etc. So I tried to put in ORDER BY 'rank_num' DESC in the place where is supposed to go but it dosent work, I dont get an error, it just dosent work. Can someone help me with this? Ive tried every possible thing I can think of with this simple order by thing. I realize the ORDER BY isnt in the script below, im asking how to add it. Ive only been trying to learn php for 4 days now so gimme a break. Any help appreciated. I promise when I become a PHP master ill contribute back 🙂

echo "<center><table><tr><td width=100 bgcolor=#EAEAEA>Member</td><td width=100 bgcolor=#EAEAEA>Gamertag</td><td width=100 bgcolor=#EAEAEA>Rank</td><td width=50 bgcolor=#EAEAEA>Number</td><td width=100 bgcolor=#EAEAEA>Origin</td></tr></table> <br>" ; 

$resultpersons = sql_query("SELECT uname, gamertag, team_rank, team_num, origin
                 FROM ".$prefix."_team", $dbi);
for ($m=0; $m < sql_num_rows($resultpersons, $dbi); $m++) { 
  list($uname, $gamertag, $team_rank, $team_num, $origin) = sql_fetch_row($resultpersons, $dbi);
  echo "<center><table><tr><td width=100 bgcolor=#F7F7F7>$uname</td><td width=100 bgcolor=#F7F7F7>$gamertag</td><td width=100 bgcolor=#F7F7F7>$team_rank</td><td width=50 bgcolor=#F7F7F7>$team_num</td><td width=100 bgcolor=#F7F7F7>$origin</td></tr></table> <br>" ;  

}

See it in action