Results Not displaying

[treeleaf20]

i have this code and for some reason its not displaying any results. Its giving me and error of Wrong parameter count for mysql_result(). Can anyone please help me out. Thank you in advance!

php:

elseif($command=="viewusers"){
$sql = "SELECT * FROM usage";
//echo $sql;
$result = mysql_query($sql) or die(mysql_error());
echo "<table>";
if (mysql_num_rows($result) > 0) {

for ($j = 0; $j<mysql_num_rows($result); $j++) {
echo "<tr>";
echo "<td>";
mysql_result($result, $j);
echo "</td>";
echo "</tr>";

}
}
echo "</table>";
}
?>

[XeRoZeN]

php:

elseif($command=="viewusers"){
$sql = "SELECT * FROM usage";
//echo $sql;
$result = mysql_query($sql) or die(mysql_error());
echo "<table>";
if (mysql_num_rows($result) > 0) {

for ($j = 0; $j<mysql_num_rows($result); $j++) {
echo "<tr>";
echo "<td>";
mysql_result($result, $j);
echo "</td>";
echo "</tr>";

}
}
echo "</table>";
}
?> [/B]

Hmmm.. the

if (mysql_num_rows($result) > 0) {

line I think you should change it to if(mysql_num_rows($result)) { instead. and does it display a error? what does it display for you?

I SEE Theres the problem.. mysql_result? use mysql_fetch_array() instead..

[treeleaf20]

mysql_fetch_array(): The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH

That is the error I get when I use this code:
elseif($command=="viewusers"){
$sql = "SELECT * FROM usage";
//echo $sql;
$result = mysql_query($sql) or die(mysql_error());
echo "<table>";
if (mysql_num_rows($result) > 0) {
for ($j = 0; $j<mysql_num_rows($result); $j++) {
echo "<tr>";
echo "<td>";
mysql_fetch_array($result, $j);
echo "</td>";
echo "</tr>";

}
}
echo "</table>";
}

[XeRoZeN]

Jeez your sopose to add the PHP code in

 tags and the problem is you did the syntax wrong.. mysql_fetch_array($result, MYSQL_NUM); 

Next time and at least look at php.net

[treeleaf20]

With your suggestion nothing shows up, but I don't have any errors just a blank screen when that is called...