pelangi pixel 0 Report post Posted November 21, 2008 Saya nk tanye camne nk cari min n max value dari recordset yang ade dalam pageSql utk recordset saye: contoh :table: evaluationlect id | eva_a1 | eva_a2 | eva_a31 2 2 21 3 3 32 1 1 13 2 4 43 1 3 3then pas sqlRecordset(Recordset8)SELECT lect_id,sum(eva_a1+eva_a2+eva_a3)FROM evaluationGROUP BY lect_idoutput:lect id | sum1 152 33 17so.. cmne nk cari lect_id mane yang ade sum paling max n paling min..saye try create view utk wat virtual table gune sqlyog tapi tak leh...thank u ps: confused nk post kt sql ke kt php Quote Share this post Link to post Share on other sites