Optimize All Tables In A MySQL Database October 22, 2008

<?php
//Database connection
$alltbls = mysql_query("SHOW TABLES");
while ($table = mysql_fetch_assoc($alltbls))
{
   foreach ($table as $db => $tablename)
   {
      mysql_query("OPTIMIZE TABLE '".$tablename."'")
      or die(mysql_error());
   }
}
?>

How to calculate the difference between two dates October 17, 2008

long diffInMilleseconds = end.getTime() – start.getTime();

long noofdays=diffInMilleseconds/86400000;

long diffInSeconds = diffInMilleseconds/1000;
long diffInMinutes = diffInSeconds/60;
long diffInHours = diffInMinutes/60;
long diffInDays = diffInHours/24;