determining time a query took

[sfullman]

<edited:>
ps. in case the answer is no on this one, here is the code I used which works:
list($usec0, $sec0) = explode(' ',microtime());
$result=mysql_query($sql,$$cnxString);
list($usec1, $sec1) = explode(' ',microtime());
$qr[time]=$sec1+$usec1-$sec0-$usec0;

this will tell you the REAL time it took for the query I suppose, not just the time from the time mySQL got the query and returned the result..
</edited>

PHPmyAdmin tells you how long the query took. Is there a php function like mysql_info() which will return this data on the previous query? I suppose I could use microtime but wanted to avoid it. I can't find this function at php.net or here after a search.

Thanks,
Sam

[nemonoman]

There's no built-in MySQL function. The one you posted is typical of others I've seen.

[devinemke]

Originally posted by nemonoman
There's no built-in MySQL function.

you sure? whenever you run a mySQL query from the command line it spits out the result and tells you the time it took at the bottom. i assume phpMyAdmin is simply echoing that to the browser.

[nemonoman]

assume away. I just looked at the MySQL functions in the PHP manual, and there's none, at least for PHP 4