Incrementing numbers help

[mrjonnytou]

I have a query which i extract a value (Integer) from. I would like to take this number and increment it by 0.1.

 

Any guidance would be appreciated.

 

Do I need to change the datatype in the database table or something???

 

<?php $new_number = $number + 0.1; ?>  ...???

[Mchl]

$number += 0.1;

[trq]

Are you saying you want to increment them within the database? Then you would need store your numbers as floats not ints.

 

Otherwise, the code you have posted works fine in php.

 

<?php

 $i = 1;
 $x += 0.1;
 echo $x . "\n";

?>