summing a row in mysql
Posted by doubleclick (doubleclick), 11 February 2005Not 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
Posted by admin (Graham Ellis), 11 February 2005You could
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: email@example.com • WEB: http://www.wellho.net • SKYPE: wellho