math calculations

[leena]

Hello everyone,

I am really stuck! Right now I have a field that would look something like this:
$StandingGF/$StandingGA

"StandingGF" and "StandingGA" are fields in the database.

$myCalculation="$StandingGF /$StandingGA";
I found a way to get those values out of the equation; I used:

list($restOfString, $theFieldTemp) = split ("$", $myCalculation, 2);
list($theField1, $restOfString) = split (" ", $theFieldTemp, 2);

list($restOfString, $theFieldTemp1) = split ("$", $restOfString, 2);
list($theField2, $restOfString) = split (" ", $theFieldTemp1, 2);

So now $theField1=StandingGF
AND $theField2=StandingGA

SO I used these two fields now to query the database:
$sql="SELECT $theField1, $theField2
FROM MyTable
WHERE .....";

I put the results from the query into an array (statArray). Now how do I take the first value, and put it in the spot of $StandingGF in the equation? And how do I get the second value in the place of $StandingGA in the equation??

Now I have those values, but how do I assign them back to the original field names?

This is what I tried:
for($i=0;$i<sizeof($statArray);$i++){
$$theField1=$statArray[$i][0];
$$theField2=$statArray[$i][1];
}

$string = str_replace(" ", "", $myCalculation);
$answer=$string;
print"answer to Calculation:$answer";

And all it does is print:
"answser to Calculation:$StandingGF /$StangingGA"

It is not actually putting the values in $StandingGF and $StandingGA in the equation...

Does anyone know how I might approach this??
Any help is greatly appreciated. Thanks for your time!

[rinjani]

I cannot understand exactly how many things you are asking but:

$myCalculation="$StandingGF /$StandingGA";

will print out the text you have asigned to the variable.

if you want a calculation to be done change the assignment, as in:

$myCalculation= ($StandingGF /$StandingGA);

I couldn't see what you were trying to do in the scond part of your question since you aren't using the query result in your printed output.

If you can explain more of what you want I can try to help some more.

[Phantazm]

Boy... that's a ton of code to try to sift through.

First off...

$myCalculation= ($StandingGF /$StandingGA);

That, as rinjani said, should solve the calculation problem itself. But also, as rinjani said, I'm not sure what else you're asking.

Please post some actual code from the problem program if you need forther assistance.

Use the "[ php ] and [ /php ]" tags (without spaces) to better organize your code. It makes it a heck of a lot easier to read 🙂

[leena]

Hello,

Ok, we will start with this:

If I have a field in a database table called "formula", and I get that formula out, and it looks like this:

$formula="($StandingGF/$StandingGA)"; // this is a string

If I can get those variables $StandingGF and $StandingGA...

$StandingGF=5;
$StandingGA=2;

Then can I do this:
$answer=$formula;

and have the answer to that equation?

So What I really want is to make sure answer is this:
$answer=(5/2);

rather than:
$answer=($StandingGF/$StandingGA);

I hope this made sense.
Thanks for your time.

[rinjani]

$StandingGF=5;
$StandingGA=2;

$formula="($StandingGF/$StandingGA)";

$answer=$formula;

print "Answer = $answer";

and you should see (at least that's what I got):

Answer = (5/2).

HTH

[leena]

sorry,

Actually what I wanted was for the answer to actually be
the answer of 5/2, which would b 2.5.

Does anyone know what I am doing wrong?

Thanks,
Lena