MySQL PHP - Time of answer

[Marek]

I have MySQL database and using PHP i make various questions. How can I get
"time of answer" from MySQL in order to show it on site generated by PHP?

--
Mark

[Pedro Graca]

Marek wrote:

I have MySQL database and using PHP i make various questions. How can I get
"time of answer" from MySQL in order to show it on site generated by PHP?

I think it would be better to do it at the php side.

<?php
$start = microtime();

// do your SQL and other stuff
sleep(10);

$finish = microtime();
$time_taken = array_sum(explode(' ', $finish))-array_sum(explode(' ', $start));
echo number_format($time_taken, 2), " seconds<br/>\n";
?>
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--