How to display total queries executed..[PHP/mySQL]

[REY619]

Hi.. I have a php/mysql running site.. I want to display the number of total queries executed, at the bottom of the pages.. Like this -

I know how to display the page creation time, but cant figure out how to display total queries executed.. Any help will be much appreciated.

Thanx.

 

[hammerhead]

One way could be creating a table and storing the query count there. By creating a trigger for that table you could increment the count and display it via the php page.

If you want the query to be seperate for different users then you can simply create a session variable and increment it each time a query is fired, and display it on bottom of the page.