This program will ask how many numbers you want to find the average of, then it will allow you to enter your numbers(yes they can even be decimals) then it will calculate the mean, median, mode and range of what you enter.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001275s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.066420s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.005469s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001559s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001340s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003429s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000793s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003554s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.021511s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001099s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 574243 [ RunTime:0.014029s ]