Getting the time a mySQL query took

[flyhoney]

I am writing a search function for a website I have been building. I wanted to display the amoun of time a specific query took on the search page. Ive seen this done on other websites, is there a way to do this with mySQL?

[samshel]

As far as i remember Mysql doesnt provide you this data, but you can calculate it like this...

[code]
       list($usec, $sec) = explode(' ',microtime());
        $querytime_before = ((float)$usec + (float)$sec);

        $result   = mysql_query($query);

        list($usec, $sec) = explode(' ',microtime());
        $querytime_after = ((float)$usec + (float)$sec);

        $time_taken = $querytime_after - $querytime_before;

[/code]

[flyhoney]

I used the code you posted and it works great. I really appreciate it, makes my search even snazzier.