jXMgvUQ8

1<sql>
2-- Структура таблицы `date_dafault`
3--
4
5CREATE TABLE IF NOT EXISTS `date_dafault` (
6  `id` INT(1) NOT NULL AUTO_INCREMENT,
7  `date_default` DATE NOT NULL,
8  PRIMARY KEY  (`id`)
9) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
10
11--
12-- Дамп данных таблицы `date_dafault`
13--
14
15INSERT INTO `date_dafault` (`id`, `date_default`) VALUES
16(1, '2012-08-14');
17</sql>
18<br><br>
19	
20"UPDATE `date_dafault` set date_default=NOW() WHERE id=1"
21	
22$id = 1;
23$today = date("Y-m-d");
24$request = "UPDATE date_dafault SET date_default = $today WHERE id = $id;";
25mysql_query($request);
26	
27UPDATE `date_dafault` set date_default=CURRENT_TIMESTAMP WHERE id=1