Subtracting a number from mysql query

[chuckie]

Can some one please tell me how i can do 100 - $myrow["rating"]
so if rating was 80 i would get an answer of 20

thanks

[AQHost]

Hi Chuckie,

Try this:

$tempvar = $myrow["rating"];
$tempvar = settype($tempvar, "float");
$result = (100-$tempvar);

This assumes you're using PHP 4.2.0 or higher, otherwise use "double" instead of "float".

Best wishes,
Simon.

[PhaZZed]

I would imagine u just read the variable from the row using an array and loop, then just do:

$tempvar = ($myrow["rating"] - 100);

something along those lines, I am worried about that code the person before me pasted.

Oh well, hope u manage to get it working!

ciao

[AQHost]

Originally posted by PhaZZed
I am worried about that code the person before me pasted.

😕 All my code does is read the value of $myrow["rating"] into a temporary variable, ensure that the variable type is numeric (i.e. float) and then perform the subtraction. What on earth is there to worry about?

Simon.