Help needed how to make a simple calculation

Goldenlamp

Hey.
Does some knows how to make a calculation from row in sql, by calculate the $row['tax] plus the $row['tax2']
😕


Person navn
<?php
$conn1 = mysql_connect("localhost", "root", "");
mysql_select_db('news_sql', $conn1);

$result = mysql_query("SELECT * FROM news ORDER BY navn DESC", $conn1); 
while( $row = mysql_fetch_array($result) ) 
     {
	  echo "&nbsp&nbspUdgift Timer (Person).:&nbsp&nbsp"; 
	  echo $row['tax'];
	  echo "&nbsp&nbspInkomst Timer (Firma).:&nbsp&nbsp";
	  echo $row['tax2'];

?>

laserlight

Since you already have them as PHP variables, just write $row['tax] + $row['tax2'].

Goldenlamp

Hey laserlight
It's still the same the calulation just output the taxtax2 (number!!)

<?php
$conn1 = mysql_connect("localhost", "root", "");
mysql_select_db('news_sql', $conn1);

$result = mysql_query("SELECT * FROM news ORDER BY newsid DESC", $conn1); 
while( $row = mysql_fetch_array($result) ) 
     {
	  echo "&nbsp&nbspUdgift Timer (Person).:&nbsp&nbsp"; 
	  echo $row['tax'];
	  echo "&nbsp&nbspInkomst Timer (Firma).:&nbsp&nbsp";
	  echo $row['tax2'];

$total =  $row['tax'] + $row['tax2'] ;
echo $total;


the result are : taxtax2

It don't calculate the number, but output the the nembers together!!!

laserlight

What is the exact output when you run this?

<?php
$conn1 = mysql_connect("localhost", "root", "");
mysql_select_db('news_sql', $conn1);

$result = mysql_query("SELECT tax, tax2 FROM news ORDER BY newsid DESC", $conn1);
while ($row = mysql_fetch_assoc($result))
{
    echo $row['tax'] . ' + ' . $row['tax2'] . ' = '
        . ($row['tax'] + $row['tax2']) . "<br />\n";
}

?>

Goldenlamp

Hey..

Its still the same.. In my table are record of tax = 72 and 0... and in tax2 = 56 and 58.

the output of this php code give a result:

72 = 72
= 0
56 = 56
58 + = 58

I need it to make a calculation of 72+0+56+58 result = 186

I hope that someone can help

laserlight

Oh, I think I am starting to understand. You want to sum the tax and tax2 columns into one result, right?

The solution should be this:

<?php
$conn1 = mysql_connect("localhost", "root", "");
mysql_select_db('news_sql', $conn1);

$result = mysql_query("SELECT SUM(tax + tax2) AS tax_total FROM news", $conn1);]
echo mysql_result($result, 0);
?>

My SQL syntax may be incorrect though (but that's unlikely), so do not be alarmed if it fails.

Why do you have both a tax and a tax2 column in the first place?

Goldenlamp

It because I have a registre amout of used time in tax of personal and amout of time in tax2 of income company..
tax - or + tax2 = total time of not used!! or used!!

An error has come by running the code! Parse error: syntax error, unexpected ']' in C:\xampp\htdocs\news\beregn.php on line 5

1. <?php
2. $conn1 = mysql_connect("localhost", "root", "");
3. mysql_select_db('news_sql', $conn1);
4.
5. $result = mysql_query("SELECT SUM(tax + tax2) AS tax_total FROM news", $conn1);]
6. echo mysql_result($result, 0);
?>

laserlight

Well, it turns out that I made a typo error. I hope you can fix it yourself. Look at the end of line 5.

Goldenlamp

Of couse, Thanks laserlight...

Be 🆒