UBB.Developers Forums Community Development Programming PHP and Server-side Scripting PHP Array Assistance please

I am attempting to use a database to rank a set of Teams for my site.

I have ten teams and need to Display them in order in a table.

I know how to structure my query to get the information that I want but I need to know how to use the information.

code:
 $query = "SELECT T_Name,T_Score,T_Rank 
     	FROM  {$config['tbprefix']}teams 
     	ORDER BY T_Rank ASC 
    "; 
   $sth = $dbh -> do_query($query); 
   $total = $dbh -> total_rows($sth); 
 
 
   for($i=0;$i<=10;$i++){ 
 
      list ($name,$score) = $dbh -> fetch_array($sth); 
 
     $userrow[$i]['teamname'] = $name; 
     $userrow[$i]['teamscore'] = $score; 
      } 
   $dbh -> finish_sth($sth); 
echo "{$userrow[$i]['teamname']}"; 
 

---

Above is what I have so far but it does not seem to be doing the desired effect.

I would like:

Ranked #1 :TeamA Score
Ranked #2 :TeamD Score
Ranked #3 :TeamB Score
Ranked #4 :TeamC Score

To get the above information I would like to use the Rank # in my HTML.
i.e.

code:
 
Rank #1 :$rank1[teamname] $rank1[score] 
Rank #2 :$rank2[teamname] $rank2[score] 

---

Any assistance appreciated.....

I think you are close. A slight change is needed in how the array is referenced. Also, the row you are referencing will be one less than your rank #, since you are starting the loop with $i=0

code:
 
Rank #1 :$userrow[0][teamname] $userrow[0][score] 
Rank #2 :$userrow[1][teamname] $userrow[1][score] 

---

Thanks for the reply Scream,
Here is what I tried

code:
 
$query = "SELECT T_Name,T_Score,T_Rank 
     	FROM  {$config['tbprefix']}teams 
     	ORDER BY T_Rank ASC 
    "; 
   $sth = $dbh -> do_query($query); 
   for($i=0;$i<=10;$i++){ 
 
     list ($name,$score) = $dbh -> fetch_array($sth); 
     $userrow[$i]['teamname'] = $name; 
     $userrow[$i]['teamscore'] = $score; 
      } 
   $dbh -> finish_sth($sth); 
echo "$userrow[0][teamname] $userrow[0][score]<br />"; 
echo "$userrow[1][teamname] $userrow[1][score]<br />"; 

---

And here are my results. http://www.unnecessaryroughness.com/test.php

What else am I missing?

How about:

code:

$query = "
        SELECT T_Name,T_Score,T_Rank
     	FROM  {$config['tbprefix']}teams
     	ORDER BY T_Rank ASC
    ";
   $sth = $dbh -> do_query($query);
   for($i=1;$i<=10;$i++){

     echo "<table>";
     list ($name[i],$score[i],$rank[i]) = $dbh -> fetch_array($sth);
     echo "<tr><td>Rank: $rank[i]</td><td>   Team: $name[i]</td><td>   Score: $score[i]</td></tr>";
    }
   echo "</table>";
   $dbh -> finish_sth($sth);

---

Having the $name and $score variables use the $i variable will let you use them as unique links or variables down the road too.