how to get the total

[mychikka]

I have two inputs box in PHP and I wanted to add third box to get the total. Originally the code will fetch if there's a current value on the table, other wise the third box will compute whatever number are there in my two boxes.

echo "Value1";
$result = mysql_query("select Total from tbl1 where ID='{$id}' ");    $row = mysql_fetch_assoc($result);
$Total1 =  $row['Total'];
 
echo "Value2";
$result = mysql_query("select Total from tbl2 where ID='{$id}' ");    $row = mysql_fetch_assoc($result);
$Total2=  $row['Total'];            
 
//from here i dont know how to compute the sum of the two        
ehco "Total Value" <input type='text'  value=$Total1+Total2>
 

[TheServant]

@mychikka
1. You misspelled echo.
2. You have html out of the string, so Total Value is a string and all that follows php will attempt to run as PHP, but it's not so you will get an error.

Try:

$total = $Total1+$Total2;
echo "Total Value: <input type='text' value='$total' />";

Hope that helps.

[mychikka]

How can I make the text box to do automatic calculation everytime the user changes the input box total?

@TheServant

[Dormilich]

@mychikka
does that have anything to do with your PHP code? (your values came from DB…)

[mychikka]

HI Dormilich... but sometimes the user input value on the text box if the value is zero. Actually my goal here is to have a pop-up message box if its over a 100 in total.

I think i need your help to place this on java script section.

thanks!

[Dormilich]

[[ moving to Javascript Forum ]]

that depends on which values you want to add (or rather, how you can access them)

[mychikka]

anybody can show me how to this?

the value will be coming from my PHP form

$total = $Total1+$Total2; 
echo "Total Value: <input type='text' value='$total' />"; 

when the user hit the save button it will pop a message alert if the total is over 100.


Please advice.

[Dormilich]

provided you make the elements accessible (using an id)

// save button
var save = document.getElementById("save");
// total field
var total = document.getElementById("total");
// define the popup
var popup = function()
{
  if (total.value > 100)
  {
    alert("value too big!");
    total.focus();
  }
}
// define the event
// google for the addEvent() function
addEvent(save, "click", popup, false);