Форумы портала PHP.SU :: Версия для печати :: Как разбить дату, что бы получился календарь

1. darksmoke - 16 Сентября, 2014 - 10:21:37 - перейти к сообщению
Добрый день
не как не могу решить задачу. Есть в базе данные
CODE (SQL):
скопировать код в буфер обмена
 
CREATE TABLE IF NOT EXISTS `archive` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name` tinytext NOT NULL,
  `rub_buy` decimal(7,4) NOT NULL,
  `rub_sell` decimal(7,4) NOT NULL,
  `usd_buy` decimal(7,4) NOT NULL,
  `usd_sell` decimal(7,4) NOT NULL,
  `eur_buy` decimal(7,4) NOT NULL,
  `eur_sell` decimal(7,4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1216 ;
 
--
-- Дамп данных таблицы `archive`
--
 
INSERT INTO `archive` (`id`, `date`, `name`, `rub_buy`, `rub_sell`, `usd_buy`, `usd_sell`, `eur_buy`, `eur_sell`) VALUES
(1, '2014-07-13', 'Кредит Днепр', '0.3350', '0.3650', '11.6500', '11.8700', '15.8000', '16.6000'),
(2, '2014-07-13', 'Альфа Банк', '0.3300', '0.3580', '11.5500', '11.9000', '15.7300', '16.3800'),
(3, '2014-07-13', 'Приват Банк', '0.3300', '0.3800', '11.6000', '11.9000', '15.6000', '16.6000'),
(4, '2014-07-13', 'Райффайзен Банк Аваль', '0.3320', '0.3560', '11.5000', '11.9500', '15.6000', '16.5500'),
(5, '2014-07-13', 'Дельта Банк', '0.3200', '0.3510', '11.0500', '11.8800', '15.4500', '16.2000'),
(6, '2014-07-13', 'UniCredit Bank', '0.3300', '0.3400', '11.6000', '11.9500', '15.8000', '16.4500'),
(7, '2014-07-13', 'OTP Bank', '0.0000', '0.0000', '11.6500', '11.9000', '15.8000', '16.2500'),
(8, '2014-07-13', 'АктаБанк', '0.3350', '0.3530', '11.6800', '11.8800', '15.7000', '16.2500'),
(9, '2014-07-13', 'VAB Банк', '0.3300', '0.3500', '11.4000', '11.8000', '15.4000', '16.2000'),
(10, '2014-07-13', 'Терра Банк', '0.3400', '0.3475', '11.6000', '11.9000', '15.8500', '16.3000'),
(11, '2014-07-13', 'Аксиома Банк', '0.3430', '0.3530', '11.7200', '11.9000', '16.0200', '16.4000'),
(12, '2014-07-13', 'Ощадбанк', '0.3300', '0.3550', '11.5500', '11.9000', '15.6500', '16.3500'),
(13, '2014-07-13', 'УкрСиббанк', '0.3340', '0.3590', '11.4000', '11.9500', '15.5000', '16.5000'),
(14, '2014-07-13', 'Укрэксимбанк', '0.3380', '0.3500', '11.5000', '11.8800', '15.8000', '16.2800'),
(15, '2014-07-13', 'ПУМБ', '0.3400', '0.3500', '11.7000', '11.9500', '15.8000', '16.2000'),
(16, '2014-07-13', 'СБЕРБАНК РОССИИ', '0.3340', '0.3580', '11.4000', '11.9000', '15.4000', '16.4400'),
(17, '2014-07-13', 'ВТБ Банк', '0.3350', '0.3620', '11.4500', '11.9500', '15.5100', '16.3500'),
(18, '2014-07-13', 'ИМЭКСБАНК', '0.3200', '0.3480', '11.5500', '11.9000', '15.3500', '16.3500'),
(19, '2014-07-13', 'ЕВРОГАЗБАНК', '0.3300', '0.3500', '11.4000', '11.9500', '15.5000', '16.4000'),
(20, '2014-07-14', 'Кредит Днепр', '0.3350', '0.3650', '11.6500', '11.8700', '15.8000', '16.6000'),
(21, '2014-07-14', 'Альфа Банк', '0.3300', '0.3550', '11.5500', '11.9000', '15.7500', '16.4000'),
(22, '2014-07-14', 'Приват Банк', '0.3300', '0.3800', '11.6000', '11.9000', '15.6000', '16.6000'),
(23, '2014-07-14', 'Райффайзен Банк Аваль', '0.3310', '0.3560', '11.5000', '11.9500', '15.4000', '16.5500'),
(24, '2014-07-14', 'Дельта Банк', '0.3210', '0.3530', '11.0500', '11.8600', '15.4500', '16.1400'),
(25, '2014-07-14', 'UniCredit Bank', '0.3300', '0.3450', '11.6000', '11.9500', '15.8000', '16.4500'),
(26, '2014-07-14', 'OTP Bank', '0.0000', '0.0000', '11.6500', '11.9000', '15.8000', '16.2500'),
(27, '2014-07-14', 'АктаБанк', '0.3320', '0.3500', '11.6800', '11.8800', '15.7000', '16.2500'),
(28, '2014-07-14', 'VAB Банк', '0.3300', '0.3500', '11.4000', '11.8000', '15.4000', '16.2000'),
(29, '2014-07-14', 'Терра Банк', '0.3400', '0.3470', '11.6000', '11.9000', '15.8500', '16.3000'),
(30, '2014-07-14', 'Аксиома Банк', '0.3400', '0.3490', '11.7200', '11.9000', '16.0200', '16.4000'),
(31, '2014-07-14', 'Ощадбанк', '0.3300', '0.3550', '11.5800', '11.9000', '15.6500', '16.3400'),
(32, '2014-07-14', 'УкрСиббанк', '0.3330', '0.3580', '11.4500', '11.9500', '15.5500', '16.5000'),
(33, '2014-07-14', 'Укрэксимбанк', '0.3380', '0.3480', '11.5000', '11.8800', '15.8000', '16.2300'),
(34, '2014-07-14', 'ПУМБ', '0.3375', '0.3475', '11.6500', '11.9500', '15.8000', '16.2000'),
(35, '2014-07-14', 'СБЕРБАНК РОССИИ', '0.3320', '0.3560', '11.4000', '11.9000', '15.4000', '16.4000'),
(36, '2014-07-14', 'ВТБ Банк', '0.3310', '0.3620', '11.4500', '11.9500', '15.5000', '16.3500'),
(37, '2014-07-14', 'ИМЭКСБАНК', '0.3200', '0.3480', '11.5500', '11.8500', '15.3500', '16.3500'),
(38, '2014-07-14', 'ЕВРОГАЗБАНК', '0.3300', '0.3570', '11.4000', '11.9500', '15.5000', '16.4000'),
(39, '2014-07-15', 'Кредит Днепр', '0.3350', '0.3650', '11.6600', '11.8900', '15.8000', '16.6000'),
(40, '2014-07-15', 'Альфа Банк', '0.3320', '0.3530', '11.5800', '11.9000', '15.8000', '16.4000'),
(41, '2014-07-15', 'Приват Банк', '0.3300', '0.3800', '11.6000', '11.9000', '15.6000', '16.6000'),
(42, '2014-07-15', 'Райффайзен Банк Аваль', '0.3290', '0.3540', '11.5000', '11.9500', '15.6000', '16.5800'),
(43, '2014-07-15', 'Дельта Банк', '0.3200', '0.3530', '11.0000', '11.8500', '15.4500', '16.1300'),
(44, '2014-07-15', 'UniCredit Bank', '0.3300', '0.3400', '11.6000', '11.9500', '15.8000', '16.4500'),
(45, '2014-07-15', 'OTP Bank', '0.0000', '0.0000', '11.6500', '11.9000', '15.8000', '16.2500'),
(46, '2014-07-15', 'АктаБанк', '3.3000', '3.4800', '11.6500', '11.8500', '15.7000', '16.2500'),
(47, '2014-07-15', 'VAB Банк', '0.3300', '0.3500', '11.4500', '11.8500', '15.4000', '16.2000'),
(48, '2014-07-15', 'Терра Банк', '0.3370', '0.3460', '11.6000', '11.9000', '15.8500', '16.3000'),
(49, '2014-07-15', 'Аксиома Банк', '0.3380', '0.3490', '11.7200', '11.9000', '16.0200', '16.4200'),
(50, '2014-07-15', 'Ощадбанк', '0.3300', '0.3550', '11.5800', '11.9000', '15.7000', '16.3500'),
(51, '2014-07-15', 'УкрСиббанк', '0.3310', '0.3570', '11.4500', '11.9500', '15.5500', '16.4800'),
(52, '2014-07-15', 'Укрэксимбанк', '0.3370', '0.3470', '11.5000', '11.8800', '15.8000', '16.2300'),
(53, '2014-07-15', 'ПУМБ', '0.3375', '0.3475', '11.6500', '11.9500', '16.0000', '16.4000'),
(54, '2014-07-15', 'СБЕРБАНК РОССИИ', '0.3300', '0.3550', '11.4000', '11.9000', '15.4300', '16.4400'),
(55, '2014-07-15', 'ВТБ Банк', '0.3300', '0.3570', '11.4500', '11.9500', '15.5100', '16.3800'),
(56, '2014-07-15', 'ИМЭКСБАНК', '0.3200', '0.3480', '11.6000', '11.9000', '15.3500', '16.3500'),
(57, '2014-07-15', 'ЕВРОГАЗБАНК', '0.3300', '0.3570', '11.4500', '11.9500', '15.6000', '16.4000'),
(58, '2014-07-16', 'Кредит Днепр', '0.3300', '0.3600', '11.6700', '11.8900', '15.7000', '16.4000'),
(59, '2014-07-16', 'Альфа Банк', '0.3250', '0.3530', '11.5800', '11.9200', '15.6200', '16.2700'),
(60, '2014-07-16', 'Приват Банк', '0.3200', '0.3700', '11.6000', '11.9000', '15.5000', '16.5000'),
(61, '2014-07-16', 'Райффайзен Банк Аваль', '0.3290', '0.3540', '11.5000', '11.9500', '15.6000', '16.5800'),
(62, '2014-07-16', 'Дельта Банк', '0.3150', '0.3490', '11.0000', '11.8700', '15.4500', '16.1000'),
(63, '2014-07-16', 'UniCredit Bank', '0.3300', '0.3420', '11.6000', '11.9500', '15.8000', '16.4500'),
(64, '2014-07-16', 'OTP Bank', '0.0000', '0.0000', '11.6500', '11.9000', '15.7000', '16.2000'),
(65, '2014-07-16', 'АктаБанк', '0.3300', '0.3480', '11.6500', '11.8900', '15.6500', '16.2000'),
(66, '2014-07-16', 'VAB Банк', '0.3300', '0.3500', '11.4500', '11.8500', '15.4000', '16.1500'),
(67, '2014-07-16', 'Терра Банк', '0.3370', '0.3470', '11.6000', '11.9000', '15.8000', '16.3000'),
(68, '2014-07-16', 'Аксиома Банк', '0.3380', '0.3490', '11.7200', '11.9000', '16.0200', '16.4000'),
(69, '2014-07-16', 'Ощадбанк', '0.3300', '0.3550', '11.6000', '11.9000', '15.7000', '16.3400'),
(70, '2014-07-16', 'УкрСиббанк', '0.3310', '0.3560', '11.4500', '11.9500', '15.5000', '16.4500'),
(71, '2014-07-16', 'Укрэксимбанк', '0.3370', '0.3470', '11.5500', '11.9000', '15.8000', '16.2500'),
(72, '2014-07-16', 'ПУМБ', '0.3375', '0.3475', '11.6500', '11.9500', '15.8000', '16.2000'),
(73, '2014-07-16', 'СБЕРБАНК РОССИИ', '0.3300', '0.3540', '11.4000', '11.9000', '15.3800', '16.4000'),
(74, '2014-07-16', 'ВТБ Банк', '0.3300', '0.3570', '11.4500', '11.9500', '15.4500', '16.3000'),
(75, '2014-07-16', 'ИМЭКСБАНК', '0.3200', '0.3460', '11.6000', '11.8700', '15.3500', '16.3500'),
(76, '2014-07-16', 'ЕВРОГАЗБАНК', '0.3300', '0.3570', '11.4500', '11.9500', '15.6000', '16.4000'),
(77, '2014-07-17', 'Кредит Днепр', '0.3300', '0.3600', '11.7100', '11.8900', '15.7000', '16.4000'),
(78, '2014-07-17', 'Альфа Банк', '0.3200', '0.3500', '11.5800', '11.9200', '15.5200', '16.2200'),
(79, '2014-07-17', 'Приват Банк', '0.3200', '0.3700', '11.6000', '11.9000', '15.4000', '16.5000'),
(80, '2014-07-17', 'Райффайзен Банк Аваль', '0.3290', '0.3530', '11.5000', '11.9500', '15.5000', '16.4800'),
(81, '2014-07-17', 'Дельта Банк', '0.3180', '0.3470', '11.1000', '11.8700', '15.4500', '16.1000'),
(82, '2014-07-17', 'UniCredit Bank', '0.3300', '0.3420', '11.7000', '11.9700', '15.9000', '16.4500'),
(83, '2014-07-17', 'OTP Bank', '0.0000', '0.0000', '11.6500', '11.9000', '15.7000', '16.2000'),
(84, '2014-07-17', 'АктаБанк', '0.3300', '0.3480', '11.6500', '11.8900', '15.6500', '16.2000'),
(85, '2014-07-17', 'VAB Банк', '0.3200', '0.3470', '11.4500', '11.8500', '15.4000', '16.1000'),
(86, '2014-07-17', 'Терра Банк', '0.3300', '0.3400', '11.6000', '11.9000', '15.7500', '16.2000'),
(87, '2014-07-17', 'Аксиома Банк', '0.3350', '0.3450', '11.7200', '11.9000', '16.0200', '16.3900'),
(88, '2014-07-17', 'Ощадбанк', '0.3300', '0.3530', '11.6200', '11.9200', '15.6800', '16.3000'),
(89, '2014-07-17', 'УкрСиббанк', '0.3290', '0.3540', '11.5000', '11.9500', '15.5000', '16.4300'),
(90, '2014-07-17', 'Укрэксимбанк', '0.3320', '0.3460', '11.6000', '11.9200', '15.9000', '16.3000'),
(91, '2014-07-17', 'ПУМБ', '0.3375', '0.3475', '11.6500', '11.9500', '15.8000', '16.2000'),
(92, '2014-07-17', 'СБЕРБАНК РОССИИ', '0.3270', '0.3510', '11.4000', '11.9000', '15.3300', '16.3200'),
(93, '2014-07-17', 'ВТБ Банк', '0.3270', '0.3550', '11.4500', '11.9500', '15.4100', '16.2600'),
(94, '2014-07-17', 'ИМЭКСБАНК', '0.3200', '0.3450', '11.6000', '11.9000', '15.3000', '16.3000'),
(95, '2014-07-17', 'ЕВРОГАЗБАНК', '0.3300', '0.3570', '11.4500', '11.9500', '15.6000', '16.4000'),
(96, '2014-07-18', 'Кредит Днепр', '0.3200', '0.3500', '11.7100', '11.8900', '15.8000', '16.5000'),
(97, '2014-07-18', 'Альфа Банк', '0.3100', '0.3500', '11.5800', '11.9200', '15.5200', '16.2200'),
(98, '2014-07-18', 'Приват Банк', '0.3100', '0.3700', '11.6000', '11.9000', '15.5000', '16.5000'),
(99, '2014-07-18', 'Райффайзен Банк Аваль', '0.3260', '0.3480', '11.5500', '11.9500', '15.5500', '16.4900'),
(100, '2014-07-18', 'Дельта Банк', '0.3100', '0.3430', '11.2000', '11.9000', '15.4500', '16.1000'),
 
Каждый день добавляется запись.
Хочу в результате получить такой вид

2014
Январь 1 | 2 | 3 | 4 | 5 | 6 ..
Февраль 1 | 2 | 3 | 4 | 5 | 6 ..
...
2015
Январь 1 | 2 | 3 | 4 | 5 | 6 ..
Февраль 1 | 2 | 3 | 4 | 5 | 6 ..