[SOLVED] MySql While Loop

[zackcez]

I'm trying to put this in my loop:

" . $row[$stat] . "

Where stat is this by default:

$stat = Attackxp + Woodcuttingxp + Defencexp + Strengthxp + Hitpointsxp + Rangexp + Prayerxp + Magicxp + Cookingxp + Fletchingxp + Fishingxp + Firemakingxp + Craftingxp + Smithingxp + Miningxp + Herblorexp + Agilityxp + Thievingxp + Slayerxp + Farmingxp + Runecraftingxp;

Each item in $stat is in the mysql database....How could I make this correctly work?

[lemmin]

What are the constants Attackxp, Woodcuttingxp, etc..? Are those supposed to be numerical variables? Can you be more specific as to how you are doing this?

[zackcez]

I currently have them set as big integers.

[wildteen88]

You need to explain more clearly, what do you mean by

I'm trying to put this in my loop:

" . $row[$stat] . "

What loop? What's with all those constants in the $stats variable.

[lemmin]

Oh, do you mean that your query returns all those fields (Attackxp, etc...)? If that is the case, your code would just be:

" . $row['Attackxp'] . "<br>" . $row['Woodcuttingxp'] . "<br>" . $row['Defencexp']; //etc...

 

If that isn't what you mean, you will have to be more specific.

[zackcez]

I want the Attackxp and all the others to be added up to get a sum.

[lemmin]

It would probably best to use the SUM() function in your query, or in the loop, your pseudo-code would work, you just need the right syntax:

$stat = $row['Attackxp'] + $row['Woodcuttingxp'] + $row['Defencexp'];  //etc...
echo $stat;

[zackcez]

The value then just come out as...nothing

[teynon]

here is a simple solution to your query. Instead of looping and adding and what not in PHP, let MYSQL do the adding. Here is an exampe:

 

SELECT Attackxp+Woodcuttingxp+Defencexp WHERE `ID` = 1

[zackcez]

But now How can I make it order it by the value gotten when adding them all up :s

[lemmin]

There is only going to be one value when you add them all up so how would you order them?