Sumowanie honoru

[gks0770]

mam kod :

            <td>Honor Gildii</td>
            <th><?php $honor = $f['honor']; echo $honor; ?></th>
        </tr>
        <tr>
            <td>Pozycja</td>
            <th><?php echo number_format($ii, 0, "." , ".") ?></th>
        </tr>
        <tr>
            <td>Członkowie</td>
            <th>
                <a href="membros_a.php">
                    <?php $members = $f['members']; echo $members; ?> / <?php $max_members = $f['max_members']; echo $max_members; ?> Członków  

potrzebuje aby w polu honor gildii zliczał się honor graczy którzy są w gildii., ktos coś ?

[gredier]

Wybierasz wszystkich graczy , którzy są w gildii następnie wybierasz od nich wszystkich punkty a potem to proste dodawanie można zrobić

[3nichilat0]

@gredier

Tylko poco? Wystarczy w zapytaniu wstawić takie coś:

"SELECT SUM(honor) FROM user WHERE guild_id = xxx" 

[gks0770]

coś nie tak dalej :

<div id="content">
<?php
if($nome['ally'] == 1){
$aucep = mysql_query("select * from allys where ally_name = '".$nome['ally_name']."'");
while($f = mysql_fetch_array($aucep)){
$wynik = mysql_query ("SELECT SUM($honor) FROM user WHERE guild_id = xxx");
$aliiv = mysql_query("SELECT * FROM allys ORDER BY level ASC");
$iv=-1;
$countt = mysql_num_rows($aliiv);
while ($showv = mysql_fetch_array($aliiv))
{
$iv=$iv+1;
if($showv['nivel'] == $id11) {
$ii = $countt-$iv;
}  
}
?>

<center><div id="mainbox">
        <table width="100%">
        <tbody><tr>


        </tr>

<font color="black"><b><font size="6"><?php $name = $f['ally_name']; echo $name; ?></font></b></font>

        <tr>
            <td><font color="black">Honor Gildii</td>
            <th><font color="black"><?php $honor = $f['honor']; echo $honor; ?></font></th>
        </tr>

zapytanie wstawione////

 

@Edit :

 

Próbowałem też :

<?php
if($nome['ally'] == 1){
$aucep = mysql_query("select * from allys where ally_name = '".$nome['ally_name']."'");
while($f = mysql_fetch_array($aucep)){
$honor = mysql_query ("SELECT SUM($honor) FROM user WHERE guild_id = xxx");
$aliiv = mysql_query("SELECT * FROM allys ORDER BY level ASC");
$iv=-1;
$countt = mysql_num_rows($aliiv);
while ($showv = mysql_fetch_array($aliiv))
{
$iv=$iv+1;
if($showv['nivel'] == $id11) {
$ii = $countt-$iv;
}  
}
?>

<center><div id="mainbox">
        <table width="100%">
        <tbody><tr>


        </tr>

<font color="black"><b><font size="6"><?php $name = $f['ally_name']; echo $name; ?></font></b></font>

        <tr>
            <td><font color="black">Honor Gildii</td>
            <th><font color="black"><?php $honor = mysql_query($query); echo $honor; ?></font></th>

ale efekt znikomy

[Vertoi]

coś nie tak dalej :

<div id="content">
<?php
if($nome['ally'] == 1){
$aucep = mysql_query("select * from allys where ally_name = '".$nome['ally_name']."'");
while($f = mysql_fetch_array($aucep)){
$wynik = mysql_query ("SELECT SUM($honor) FROM user WHERE guild_id = xxx");
$aliiv = mysql_query("SELECT * FROM allys ORDER BY level ASC");
$iv=-1;
$countt = mysql_num_rows($aliiv);
while ($showv = mysql_fetch_array($aliiv))
{
$iv=$iv+1;
if($showv['nivel'] == $id11) {
$ii = $countt-$iv;
}  
}
?>

<center><div id="mainbox">
        <table width="100%">
        <tbody><tr>


        </tr>

<font color="black"><b><font size="6"><?php $name = $f['ally_name']; echo $name; ?></font></b></font>

        <tr>
            <td><font color="black">Honor Gildii</td>
            <th><font color="black"><?php $honor = $f['honor']; echo $honor; ?></font></th>
        </tr>

zapytanie wstawione////

 

@Edit :

 

Próbowałem też :

<?php
if($nome['ally'] == 1){
$aucep = mysql_query("select * from allys where ally_name = '".$nome['ally_name']."'");
while($f = mysql_fetch_array($aucep)){
$honor = mysql_query ("SELECT SUM($honor) FROM user WHERE guild_id = xxx");
$aliiv = mysql_query("SELECT * FROM allys ORDER BY level ASC");
$iv=-1;
$countt = mysql_num_rows($aliiv);
while ($showv = mysql_fetch_array($aliiv))
{
$iv=$iv+1;
if($showv['nivel'] == $id11) {
$ii = $countt-$iv;
}  
}
?>

<center><div id="mainbox">
        <table width="100%">
        <tbody><tr>


        </tr>

<font color="black"><b><font size="6"><?php $name = $f['ally_name']; echo $name; ?></font></b></font>

        <tr>
            <td><font color="black">Honor Gildii</td>
            <th><font color="black"><?php $honor = mysql_query($query); echo $honor; ?></font></th>

ale efekt znikomy

ostatnio moderator mi zagroził banem jak jeszcze raz kogos obrażę, więc tego nie zrobie, ale wiedz, ze chcialbym... ty to masz zedytowac pod siebie ...