After 30 days update ?

[balkan7]

hi i need help for create code after 30 days update ?

base.sql
[code]CREATE TABLE `bsoft_catalog` (
  `ID` int(10) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL default '',
  `Desc` text NOT NULL,
  `Price` float(10,2) NOT NULL default '0.00',
  `Image` text NOT NULL,
  `Category` int(10) NOT NULL default '0',
  `Cd` int(10) NOT NULL default '0',
  `New` varchar(50) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
[/code]

and php code is:
[code]
<?php
$q1 = "select * from bsoft_catalog New = 1";
$r1 = mysql_query($q1) or die(mysql_error());
$a1 = mysql_fetch_array($r1);
// check in datebase if value=1 show picture, if 0 nothing for show
if ($a1[New] == 1) {
echo "<img src=\"images/new.gif\" />";
} ?>[/code]

so now i need code for after 30 days update in colum New value=0.

[simcoweb]

Just have the script run every 30 days as a cron job.

[balkan7]

if you have code please paste here...

[balkan7]

soryy for replay but i need this !
can someone create code for 30 days update in column new query ?