Last Updated Store in Magento

<?php
$con=mysql_connect(“localhost”,”root”,”root”);
mysql_select_db(“i-buy-express”);

$sql=”SELECT *
FROM `catalog_product_entity`
ORDER BY `catalog_product_entity`.`updated_at` DESC
LIMIT 0 , 1″;
$result=mysql_query($sql);

while($row = mysql_fetch_array($result))
{
$store_date=$row[‘updated_at’];
$store_date=date(‘d/m/Y’, strtotime($store_date));

echo “<strong> Store Updated:  “.$store_date.”</strong>”;
}
?>

Leave A Comment