本人乃编程爱好者,这个小程序实现的只是对话框的链接,虽然很简单,但是对初学者应该会有帮助的,内有详细说明步骤!-I was programming enthusiasts, this small program is the link dialog box, although very simple, but should be helpful for beginners, and there are detailed description of the steps!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.003264s ]
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.106403s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000817s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001256s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001459s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003164s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001432s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005274s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018163s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001109s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 110201 [ RunTime:0.059157s ]