alright, not sure if i can even do this or not, but i figured the list would know.
here is the query i have: SELECT count(ID),sum(pnt1)+sum(pnt2)+sum(pnt3)+sum(pnt4) FROM wiseQuiz_questions WHERE test='$test' here is the table structure i have: CREATE TABLE `wiseQuiz_questions` ( `ID` int(11) NOT NULL auto_increment, `test` int(11) default NULL, `question` text, `ans1` text, `ans2` text, `ans3` text, `ans4` text, `pnt1` int(11) default NULL, `pnt2` int(11) default NULL, `pnt3` int(11) default NULL, `pnt4` int(11) default NULL, PRIMARY KEY (`ID`) ); the values that i am concerned with are the pnt1, pnt2, pnt3 and pnt4 fields. as you can see with the query i am simply summing each of the columns. what i would like to do is out of the four fields only add the HIGHEST value to the sum. is there a way to do that? some of the values i have are below: 3 2 1 0 2 3 0 1 in this scenario i would want to see the total as 6, rather than 12. see where i am going? thanks in advance, katen --------------------------------------------------------------------- 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