This code is easy to use and implement in other porjects. The code is well commented so you will be able to understand it quickly.
Also, chk out my website for forther projects: http://hungarydan.com
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.011414s ]
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.126207s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001146s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001149s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001759s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005693s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001565s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.007657s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018581s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001573s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 63301 [ RunTime:0.010965s ]