math / mysql

[seby]

greetings.

how can i take filesize and multiply it by the total downloads and output the amount?

below is the mysql structure:

|id | filesize | downloads |
----------------------------
 1     323421        20
 2     235457        18
 3     827162        34

can anyone help, its confusing me.

[mattsinclair]

SELECT (filesize * downloads) AS bandwidth FROM TABLE WHERE 1

this will make a new variable, called bandwidth, you can use it like any other column but it will contain the product of filesize and downloads

also, you can add to it

SELECT downloads, (filesize * downloads) AS bandwidth , filesize FROM TABLE WHERE 1

don't forget to replace TABLE with your tablename