[RESOLVED] add rows together...?

[pettsogn]

In the game I've made I have added a function so that the members can create and join clans.. Now I want to create a ladder for the families but i cant figure out how to add rows togheter. I think it got something to do with loops..

the tiny piece of code I've got so far:

$result = mysql_query("SELECT id FROM clans",$db);
$info = mysql_fetch_array($result);
$clanid = $info["id"];

$result2 = mysql_query("SELECT score FROM users WHERE tagid='$clanid'",$db);

now what..? 😛

thanks 🙂

[pettsogn]

I figured it out 🙂

$result = mysql_query("SELECT * FROM clans ORDER BY id ASC LIMIT ".($a).",100",$db);


if ($myrow = mysql_fetch_array($result)) {

echo "<table width=100%>";

$count = $a1;
if ($count>0)$count--;
do {
    $myrow["tag"] = strip_tags($myrow["tag"]);
    $count++;


echo "<tr><td>";
$tagid2 = $myrow["id"];
$res = mysql_query("SELECT SUM(score2) AS poeng FROM users WHERE tagid='$tagid2'");
while ($row=mysql_fetch_array($res, MYSQL_ASSOC)) {
echo $row['score2'];
}
echo "</td></tr>";

} while ($myrow = mysql_fetch_array($result));

}