Modifying Top Module

Nuke Cadet Joined: May 25, 2005 Posts: 9

Ok, I have been at this for over 36 hours now and I am stuck. I have tried everything I could think of and I know the answer I seek has got to be right underneath my nose. Hopefully one you of can assist me with this.

What I am attemptting to do, is to totally redo my Top module so that it displays the top earner in Credits. My site is based off a RPG that myself and a few friends are designing. Below is my coding so far.

Code:

/* Top 10 Characters - Gold */

$result8 = $db->sql_query("SELECT name, Credits FROM `nuke_registry` ORDER BY Credits DESC");

if ($db->sql_numrows($result8)>0) {

echo "<table border=\"0\" cellpadding=\"10\" width=\"100%\"><tr><td align=\"left\">\n"

."$top "._CHARGOLD." \n";

$lugar = 1;

$counter = 0;

while($object = sql_fetch_object($result8, $dbi)) {

$resultArray[$counter] = array($object->Credits, $object->mame);

$counter++;

}

for ($count = 0; $count < count($resultArray); $count++) {

$id = $resultArray[$count][0];

$pollTitle = $resultArray[$count][1];

$voters = $resultArray[$count][3];

for($i = 0; $i < 12; $i++) {

 $object = sql_fetch_object($result8, $dbi);

 $optionCount = $object->optionCount;

 $sum = (int)$sum+$optionCount;

}

echo "<big>·</big> $lugar: - ($sum "._CREDITS.") \n";

$lugar++;

$sum = 0;

}

echo "</td></tr></table> \n";

}

I understand exactly whats going wrong here, its just I cant figure out how to fic it. Below is the output to the file the above script gives.

Code:

10 Richest Characters

· 1: - ( Credits Earned)
· 2: - ( Credits Earned)

Well, I hope I explained exactly what I am trying to accomplish and someone out there could kindly assist me here *is so exhausted he heads to bed!*

P.S. Hope this was the right area for this post, if not, sorry.

Edit:
The SQL query is completely correct, I just need to figure out how to get it to post the result to the web page to a maximum of 10 names and to automatically post a number before the name. Any and All help is appreciated.

Re-Edit:
YES!! Nevermind now. Took me a while but I was able to do it myself. Incase others need to do such in the future, I will include the coding I used below.

Code:

/* Top 10 Characters - Gold */

global $name, $Credits, $dbi;

echo "<table border=\"0\" cellpadding=\"10\" width=\"100%\"><tr><td align=\"left\">\n"
."Top $top "._CHARGOLD." \n";
$lugar=1;

$result=sql_query("SELECT name, Credits FROM nuke_registry ORDER BY Credits DESC LIMIT 0,10", $dbi);
while(list($name, $Credits) = sql_fetch_row($result, $dbi)) {
echo "<big>·</big> $lugar: -  $name  Credits: $Credits  \n";
$lugar++;
}

echo "</td></tr></table> \n";