Canman2005 Posted March 5, 2006 Share Posted March 5, 2006 Dear allI have a simple sql statement which adds up all the numbers in one colum of my database, the code I used is[code]$sql ="SELECT SUM(cost) as 'cost' FROM results WHERE resultid = '$resultid'";$sql = @mysql_query($total,$connection) or die(mysql_error());[/code]As well as the colum "cost" I also have another colum in my database called "costtwo"How can I get the statement to add these two coloums (cost + costtwo) and then total the rows up? Basically like it does now, but adding costtwo before it tots up the rest of the valuesIs this easy?ThanksDave Quote Link to comment https://forums.phpfreaks.com/topic/4141-adding-two-values/ Share on other sites More sharing options...
JasperBosch Posted March 5, 2006 Share Posted March 5, 2006 Hi,You mean something like this?[code]$sql ="SELECT SUM(cost + costtwo) as 'cost' FROM results WHERE resultid = '$resultid'";$sql = @mysql_query($total,$connection) or die(mysql_error());[/code]Yea, thats realy easy, isn't it? Quote Link to comment https://forums.phpfreaks.com/topic/4141-adding-two-values/#findComment-14433 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.