get total for selected record every time when checking checkbox using JavaScript

[Comskiesci]

<div style="background-color:#fffcc0; font-family:Arial, Helvetica, sans-serif; color:#000000; padding:5px; margin:auto; width:400px; height:auto;"> 
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("studentrecord", $con);

$result = mysql_query("SELECT * FROM miscellaneous");



while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<th scope='row' class='spec'>" . '<input name="selector[]" type="checkbox" value="'.$row['Misc_Code'].'">' . "</th>";
// echo "<th scope='row' class='spec'>" . '<input name="selector[]" type="checkbox" value="'.$row['Misc_Code'].'">' . "</th></br>";
echo "&nbsp;&nbsp;<td>" . $row['Misc_Code'] . "</td></br>";
echo "</tr>";
}
echo "</table>";

mysql_close($con);
?>
</div>

[Dormilich]

since you posted in the JavaScript forum, what’s with all those PHP code?

[Comskiesci]

i want to use some javascript code so that every time when i check some record it will automatically get the total value of the selected record...pls help

[Anas Mosaad]

Please note that th tag is used to add table header. You are not supposed to use it for table data. You should use td instead.

Regarding JS, adding to Dormilich say: what is your JS problem to help you in? We are not supposed to give you help with a complete solution without especially if you don't start helping yourself first. Give it a try and if you get stuck, post and we will see how we can help.

[Comskiesci]

<script type="text/javascript">
function checkTotal() {
document.listForm.total.value = '';
var sum = 0;
for (i=0;i<document.listForm.choice.length;i++) {
if (document.listForm.choice[i].checked) {
sum = sum + parseInt(document.listForm.choice[i].value);
}
}
document.listForm.total.value = sum;
}
</script>

<form name="listForm">
<input type="checkbox" name="choice" value="2" onchange="checkTotal()"/>2<br/>
<input type="checkbox" name="choice" value="5" onchange="checkTotal()"/>5<br/>
<input type="checkbox" name="choice" value="10" onchange="checkTotal()"/>10<br/>
<input type="checkbox" name="choice" value="20" onchange="checkTotal()"/>20<br/>
Total: <input type="text" size="2" name="total" value="0"/>
</form>

-----------------------------------------------
instead of the value above, now i want that value coming from mysql database. This is my code below getting record from sql

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("studentrecord", $con);

$result = mysql_query("SELECT * FROM miscellaneous");



while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<th scope='row' class='spec'>" . '<input name="selector[]" type="checkbox" value="'.$row['Misc_Code'].'">' . "</th>";

echo "&nbsp;&nbsp;<td>" . $row['Misc_Amount'] . "</td></br>";
echo "</tr>";
}
echo "</table>";

mysql_close($con);
?>