Jump to content

After 30 days update ?


balkan7

Recommended Posts

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.
Link to comment
https://forums.phpfreaks.com/topic/30506-after-30-days-update/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.