Mysql Mulitplication help

[djbuddhi]

my database field as two columns a ,b

 

SELECT (a+(a*b))  AS now_total  FROM table_name

 

let say in mathematics (a+(a*b))=x

 

this is working fine .my question is next time when performing the sql the calculation must be performed to x* (a*b)

 

the query must execute like that .how to write in SQL

ex:

a    b      x

2    5        12

12  5        72

 

the flow is like this .who 2 write the query

             

 

 

 

[corbin]

SELECT (a+(a*b))*a*b

[djbuddhi]

thanks .i  have a another question

 

 

[djbuddhi]

i want to generate this fomula

 

value =(a*b)/100

 

for the first month

a                b              value      total

 

5800            2                116      5800+116

 

for the second month

5916            2                118.32  5800+116+118.32

 

how to write this using above sql .i am still have a doubt of doing it