Forums » MySQL » MySQL Discussion

Thread: calculating marks in mysql /php

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
Pragati

Posts: 2
Registered: 11/15/11
calculating marks in mysql /php
Posted: Nov 15, 2011 3:29 AM
 
  Click to reply to this thread Reply
Attachment ngotool.zip (104.9 K)
Attachment Toadrating query.tsm (952.0 K)

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#


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums