<?php require("database.php"); $query = "select id,title,content,createtime from content order by createtime asc limit 5000"; $result = mysql_query($query,$link); $queryb = "select unix_timestamp(now()) as starttime"; $querye = "select unix_timestamp(now()) as endtime"; $resultb = mysql_query($queryb,$link); $rowb = mysql_fetch_assoc($resultb); echo $rowb['starttime']; while($array = mysql_fetch_array($result)){ ?> <dl> <dt><?php echo $array['title']."--".$array['id']."发表时间:".$array['createtime'];?></dt> <dd><?php echo $array['content']; ?></dd> </dl> <?php } $resulte = mysql_query($querye,$link); $rowe = mysql_fetch_assoc($resulte); echo $rowe['endtime']; $t = ($rowe['endtime'] - $rowb['starttime'])/1000; echo "<br/>执行时间为:".$t."s"; mysql_close($link); ?> 原文地址:http://purplegourd.com/2010/10/26/php-mysql%e7%b2%be%e7%a1%ae%e6%b5%8b%e8%af%95sql%e8%af%ad%e5%8f%a5%e6%89%a7%e8%a1%8c%e6%97%b6%e9%97%b4/