count # of mysql queries on a page

[fredouille]

Hi all

I see on several application on bottom of pages : X queries used to generate the page....any idea how to do that ?

thanks

[lazzerous]

Sure

Have an included file that you use one every page: (func.php)

function do_query($select_statement)
  {
  global $query_count;
  $q = mysql_query($select_statement);
  $query_count++;
  return $q;
  }

have each page refernce that:

$query_count = "0";
include "func.php";
$query = "select id fom table";
$q = do_query($query);
$row=mysql_fetch_array($q);


echo "$query_count queries used to generate this page.<br>\n";

-=Lazzerous=-

[fredouille]

fuck..it is simple..thanks alot !!

[lazzerous]

no prob :-D