[Luke2]

Hello there. Quick question; how can I multiply all the entries in an SQL column by a set amount. Many thanks. Luke.

Example:

Column
20 ---New Value (*2) --> 40
30 ---New Value (*2) --> 60
20 ---New Value (*2) --> 40
5 ---New Value (*2) --> 10
100 ---New Value (*2) --> 200

[404]

Not sure what you mean but you can do this:

PHP Code:

$query = mysql_query("SELECT * FROM whatever");

while ($result = mysql_fetch_array($query)){

$multiply = $result[mathrow]*5; //while 5 can be anything you want

}



echo $multiply; 

[Luke2]

Thanks 404. This was the code that I ended up using, but I see that yours would be useful, especially for more advanced operations.

PHP Code:

UPDATE table SET somevalue=somevalue*8 

I knew it would be simple, just needed some logic!