note 39702 added to function.mysql-query

Calculate how long a query takes to run using mysql_query()... <?php function mysql_query_timed($sql) { $time1 = microtime(); $resource_id = mysql_query($sql); $time2 = microtime(); $time3 = $time2-$time1; return array($resource_id,$time3); } $sql = "SELECT * FROM mytable"; $query = mysql_query_timed($sql); echo "execution time:" . $query[1]; ?> If you need to use mysql_fetch_array() on your query use $query[0] instead of $query as you normally would. <?php $fetch_rows = mysql_fetch_array($query[0]); ?> ---- Manual Page -- http://www.php.net/manual/en/function.mysql-query.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+39702 Delete -- http://master.php.net/manage/user-notes.php?action=delete+39702&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+39702&report=yes Search -- http://master.php.net/manage/user-notes.php