Not sure if this should be a php or a mysql question, since it includes both.

I have created a database in mysql, and with the help of DreamWeaver, also have a page to view and update its contents.

It's a spreadsheet kind of thing:

Name  Spelling   Math   Science    Total
Ben      12           14        11            
Mary     22           11        22
Sam       3           24        22

All the inividual numbers show up, but I can't figure out how to sum each student's scores, and put them in the web page's table in the "Total" column

Any suggestions?



You could

Code:

<?php $q = mysql_query("select * from tablename"); while ($row = mysql_fetch_assoc($q)) {        $row[total] = $row[science] + $row[spelling] +$row[math];        # Then your table display code for the row        } ?>

---