Toad World® Forums

Calculating marks in mysql /php

The ngos will fill the NGO PROFILE online (PHP/MYSQL) and NGO ACCREDITATION TOOL (PHP / MYSQL) this will be filled at the mission office. Rating / Grading of NGOs is done and marks are allocatted to individula ngos on four broad parameters like (Governance and accountability/Transparency / organnisational capacity/ Program implementation).

marks are allotted to ngos on these parameters.

I am developing db in PHP/ mysql and i am using this navicat (managing different kinds of dbs oracle/mysql/sqllite/postgressql/) / phpmyadmin(wamp server it installs apache web server/ mysql/ php all are included in an executable file wamp.exe). wamp server runs on port 80 so it should be free.

problem
Marks are allotted to individual questions and one ques is a summation of next five ques marks and now how should i calculate the marks in (PHP/mysql). Should i declare variables for individual questions and then do summation / should i write a procedure/ function in mysql / trigger in mysql.

assist me in this regard.
pragati.rch@gmail.com

demo.asprunner.net.
userid pragati.rch@gmail.com
pwd saloni

click on rating db
login rating mis
pwd Sandali#

ngotool.zip (105 KB)

Toadrating query.tsm (952 KB)