this is a query which works in mysql but does not work in the jsp
Code:
SELECT (@rownum:=@rownum+1) AS pos, fname,lastname,othername,clas,(( tblbot.mtc+tblmot.mtc+tbleot.mtc)/3+ 
(tblbot.eng+tblmot.eng+tbleot.eng)/3 + (tblbot.che+tblmot.che+tbleot.che)/3+
(tblbot.bio+tblmot.bio+tbleot.bio)/3 + (tblbot.phy+tblmot.phy+tbleot.phy)/3+ 
(tblbot.agr+tblmot.agr+tbleot.agr)/3+(tblbot.his+tblmot.his+tbleot.his)/3+ 
(tblbot.fat+tblmot.fat+tbleot.fat)/3+(
...