Hi there,
i have a similar query regarding calculated fields. i have a table
which stores the 3 test results in a particular subject. i need to find the
average of the best 2 of the tests, i.e for a entry of 46,47,48 i need to
find average of 47 and 48. as of right now i am using a field to store this
average, which i find whenever i update the above marks. ofcourse a query
would suffice in displaying the average but i think it is faster when i
calculate it once and then read it from the field directly whenever i need
to display the average.
please suggest if the strategy is wrong.
bye
Mathew
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php