A few PHP questions.

[TwiztedFake]

First
I know the standard format for date in MySql is yyyy-mm-dd but what is the standard format for time. Is it hh:mm:ss?

Second
I working on an articles section and plan track the number of views for each article how can I do this. Would something like $views = $views + 1 work?

The last question.
How can I display the number queries executed and the time it took for the server to build the page.

Thanks in advance to whomever can help me out.

 

[Eric]

1. Yes, HH:MM:SS (I'm pretty sure)
2.

mysql_query("UPDATE articles SET views = views + 1 WHERE id = 1");

3. Use a variable. $query_count.. whenever you do a query just increment it.

And finally, maybe something like this

<?php

$time = explode(" ", microtime());
$time = $time[1] + $time[0];
$start = $time;

//Your code.....


$time = explode(" ", microtime());
$time = $time[1] + $time[0];
$finish = $time;
$totaltime = ($finish - $start);
printf("Page loaded in %f seconds.", $totaltime);

?>

Hope that helps.

-Eric

 

[TwiztedFake]

Thanks! Should help out a bunch since I'm tweaking my original code for a site.