Last Updated

<div class="ftr_last_updated clear"> <?php print t('Last Updated on:'); ?>
  <?php
       $format2 = 'd-m-Y';
       $result2 = db_query("SELECT title, changed FROM {node} WHERE status = 1 ORDER BY changed DESC");
        if ($node = db_fetch_object($result2)) {
           $output2 .= date($format2, $node->changed);
         }
          print $output2;
  ?>
</div>