[RESOLVED] Adding data query together.

[Beffic]

<?php
if($blessingStats[0] == "Might" || $blessingStats[1] == "Might" || $blessingStats[2] == "Might" || $blessingStats[3] == "Might" || $blessingStats[4] == "Might"){
 $level = mysql_fetch_assoc(mysql_query("SELECT * FROM affinity WHERE name='Might'"));
 $equation = $level['level']/10;
 $total = $charstr * $equation;
 $stradd = "<font color=\'#0099FF\'>+ ".$total."</font>";
}
?>

As you can see above if you have a blessing == might, then it will divide the level to get a decimal and and multiply by the character stat in which it wants to increase to get a certain bonus.

But as you see, the if statement checks to see if any of the $blessingStats[0] are equal to might and if it is multiply $charstr by 1.1 for example. But the blessings will be able to stack so if they have Might in $blessingStats[0], and $blessingStats[1] then it should be 1.2, but the equation stays 1.1, now my question is how do I make it add up the field then multiply?

[Beffic]

pretty much trying to add all the levels up where the blessing is == might and divide it by 10.

Mostly looking how to add the levels up.

[Haddman]

I hope I understand you correctly, if you have 1 blessing == Might then it's 1.1, if it's 2 blessings == Might then it's 1.2 etc., if so:

<?php
if ( $blessingStats[0] == "Might" || $blessingStats[1] == "Might" || $blessingStats[2] == "Might" || $blessingStats[3] == "Might" || $blessingStats[4] == "Might" )
{
	for ( $i >= 4; i = 0; i++ )
	{
		if ( $blessingStats[$i] == "Might" )
		{
			$foo += 1;
		}
	}
	$equation = $foo / 10;
	$total = $charstr * $equation;
	$stradd = "<font color='#0099FF'>+ ".$total."</font>";
}
?>

Hope that helps.

[Beffic]

Exactly! I'll give that a try. Thanks

[Beffic]

Should I have something set for $i?

[Haddman]

No, $i is just something for the "for" loop, the value has already been set inside it, notice "$i = 0;".

[Beffic]

for ( $i >= 4; $i = 0; $i++ ) 
    { 
        if ( $blessingStats[$i] == "Might" ) 
        { 
            $foo += 1; 
        } 
    } 
    $equation = $foo / 10;

I noticed that there was missing variable marks from yours in the for statement so i added then but my end result comes to = 0

[bradgrafelman]

This:

for ( $i >= 4; $i = 0; $i++ ) 

should probably have been written as this:

for ( $i = 0; $i >= 4; $i++ ) 

[Beffic]

End result is still 0. Here is the current look. Maybe it's something I am doing...

<?php
if($blessingStats[0] == "Might" || $blessingStats[1] == "Might" || $blessingStats[2] == "Might" || $blessingStats[3] == "Might" || $blessingStats[4] == "Might"){
 $level = mysql_fetch_assoc(mysql_query("SELECT * FROM affinity WHERE name='Might'"));
 for($i = 0; $i >= 4; $i++) 
 { 
    if ( $blessingStats[$i] == "Might" ) 
    { 
        $foo += $level['level']; 
    } 
 } 
 $equation = $foo / 10; 
 $total = $charstr * $equation;
 $stradd = "<font color=\'#0099FF\'>+ ".$total."</font>";
}
?>

And if the for statement starts going it will potentially remove the first if statement for me.

[laserlight]

Your loop condition is wrong: the loop will never run for even one iteration. This is how I might do it:

<?php
if (in_array('Might', $blessingStats))
{
    $result = mysql_query("SELECT level FROM affinity WHERE name='Might'");
    $level = mysql_fetch_assoc($result);
    $foo = 0;
    for  ($i = 0, $count = count($blessingStats); $i < $count; $i++)
    {
        if ($blessingStats[$i] == 'Might')
        {
            $foo += $level['level'];
        }
    }
    $equation = $foo / 10;
    $total = $charstr * $equation;
    $stradd = '<font color="#0099FF">+ ' . $total . '</font>';
}

[laserlight]

Reading your code again, I must say that something looks fishy: what you are doing is just taking the level field from the first row retrieved, and then multiplying it by the number of times an element in $blessingStats is equal to 'Might'. I suspect that you actually want to sum all the level fields in affinity where name='Might', i.e.,

<?php
$result = mysql_query("SELECT SUM(level) as level_total FROM affinity WHERE name='Might'");
$row = mysql_fetch_assoc($result);
$equation = $row['level_total'] / 10;
$total = $charstr * $equation;
$stradd = '<span style="color: #0099FF;">+ ' . $total . '</span>';

[Beffic]

I guess looking into my Mysql a little more would do me some good. I would have never thought it could do something like that, but always felt as though it should. So something new to me.

I used the first code you posted and it work. Thanks.