Новичок
Покинул форум
Сообщений всего: 2
Дата рег-ции: Сент. 2014
Помог: 0 раз(а)
|
Добрый день
не как не могу решить задачу. Есть в базе данные
damp (Отобразить)
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 ..
|