може ли някой да оправи този сял

S

Stifi

Registered
Код: 
CREATE TABLE `songs_cat` (
`id` int(4) NOT NULL auto_increment,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `songs_cat` VALUES (1, 'Áàëàäè');
INSERT INTO `songs_cat` VALUES (2, 'Club');
INSERT INTO `songs_cat` VALUES (3, 'Dance');
INSERT INTO `songs_cat` VALUES (4, 'Electronic');
INSERT INTO `songs_cat` VALUES (5, 'Gothic');
INSERT INTO `songs_cat` VALUES (6, 'Hip-Hop');
INSERT INTO `songs_cat` VALUES (7, 'JazZ');
INSERT INTO `songs_cat` VALUES (8, 'Latin');
INSERT INTO `songs_cat` VALUES (9, 'Pop');
INSERT INTO `songs_cat` VALUES (10, 'Psychedelic');
INSERT INTO `songs_cat` VALUES (11, 'R&B');
INSERT INTO `songs_cat` VALUES (12, 'Reggae');
INSERT INTO `songs_cat` VALUES (13, 'Rock');
INSERT INTO `songs_cat` VALUES (14, 'Techno');
INSERT INTO `songs_cat` VALUES (15, 'Íàðîäíè');
INSERT INTO `songs_cat` VALUES (16, 'Êþ÷åöè');
INSERT INTO `songs_cat` VALUES (17, 'Õîðà');
INSERT INTO `songs_cat` VALUES (18, 'Drum''n''Bass');
INSERT INTO `songs_cat` VALUES (19, 'Retro');
INSERT INTO `songs_cat` VALUES (20, 'Ãðúöêî');
INSERT INTO `songs_cat` VALUES (21, 'House');
INSERT INTO `songs_cat` VALUES (22, 'Jungle');
INSERT INTO `songs_cat` VALUES (23, 'Metal');
INSERT INTO `songs_cat` VALUES (24, 'Ïîï Ôîëê');
INSERT INTO `songs_cat` VALUES (25, 'Punk');
INSERT INTO `songs_cat` VALUES (26, 'Rap');
INSERT INTO `songs_cat` VALUES (27, 'Reggaeton');
INSERT INTO `songs_cat` VALUES (28, 'Ñðúáñêî');
INSERT INTO `songs_cat` VALUES (29, 'Trance');
INSERT INTO `songs_cat` VALUES (30, 'Äåòñêè');
INSERT INTO `songs_cat` VALUES (31, 'Äðóãè');

не разбирам
Äðóãè
Увеличете...
тия знаци
`+1`
 
оправи си ги там а ако използваш системата на миро има админ и там се добавят ...
 
Внимавай с encoding&collate!!! защо таблицата ти е latin1?
запази това като sql-file u после IMPORT c phpMyAdmin:
Код: 
set names cp1251;

DROP TABLE IF EXISTS `songs_cat`;
CREATE TABLE `songs_cat` (
`id` int(4) NOT NULL auto_increment,
`value` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE cp1251_bulgarian_ci;

INSERT INTO `songs_cat` VALUES (1, 'Балади');
INSERT INTO `songs_cat` VALUES (2, 'Club');
INSERT INTO `songs_cat` VALUES (3, 'Dance');
INSERT INTO `songs_cat` VALUES (4, 'Electronic');
INSERT INTO `songs_cat` VALUES (5, 'Gothic');
INSERT INTO `songs_cat` VALUES (6, 'Hip-Hop');
INSERT INTO `songs_cat` VALUES (7, 'JazZ');
INSERT INTO `songs_cat` VALUES (8, 'Latin');
INSERT INTO `songs_cat` VALUES (9, 'Pop');
INSERT INTO `songs_cat` VALUES (10, 'Psychedelic');
INSERT INTO `songs_cat` VALUES (11, 'R&B');
INSERT INTO `songs_cat` VALUES (12, 'Reggae');
INSERT INTO `songs_cat` VALUES (13, 'Rock');
INSERT INTO `songs_cat` VALUES (14, 'Techno');
INSERT INTO `songs_cat` VALUES (15, 'Народни');
INSERT INTO `songs_cat` VALUES (16, 'Кючеци');
INSERT INTO `songs_cat` VALUES (17, 'Хора');
INSERT INTO `songs_cat` VALUES (18, 'Drum''n''Bass');
INSERT INTO `songs_cat` VALUES (19, 'Retro');
INSERT INTO `songs_cat` VALUES (20, 'Гръцко');
INSERT INTO `songs_cat` VALUES (21, 'House');
INSERT INTO `songs_cat` VALUES (22, 'Jungle');
INSERT INTO `songs_cat` VALUES (23, 'Metal');
INSERT INTO `songs_cat` VALUES (24, 'Поп Фолк');
INSERT INTO `songs_cat` VALUES (25, 'Punk');
INSERT INTO `songs_cat` VALUES (26, 'Rap');
INSERT INTO `songs_cat` VALUES (27, 'Reggaeton');
INSERT INTO `songs_cat` VALUES (28, 'Сръбско');
INSERT INTO `songs_cat` VALUES (29, 'Trance');
INSERT INTO `songs_cat` VALUES (30, 'Детски');
INSERT INTO `songs_cat` VALUES (31, 'Други');
8)
 
koko5 каза:
Внимавай с encoding&collate!!! защо таблицата ти е latin1?
запази това като sql-file u после IMPORT c phpMyAdmin:
Код: 
set names cp1251;

DROP TABLE IF EXISTS `songs_cat`;
CREATE TABLE `songs_cat` (
`id` int(4) NOT NULL auto_increment,
`value` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE cp1251_bulgarian_ci;

INSERT INTO `songs_cat` VALUES (1, 'Балади');
INSERT INTO `songs_cat` VALUES (2, 'Club');
INSERT INTO `songs_cat` VALUES (3, 'Dance');
INSERT INTO `songs_cat` VALUES (4, 'Electronic');
INSERT INTO `songs_cat` VALUES (5, 'Gothic');
INSERT INTO `songs_cat` VALUES (6, 'Hip-Hop');
INSERT INTO `songs_cat` VALUES (7, 'JazZ');
INSERT INTO `songs_cat` VALUES (8, 'Latin');
INSERT INTO `songs_cat` VALUES (9, 'Pop');
INSERT INTO `songs_cat` VALUES (10, 'Psychedelic');
INSERT INTO `songs_cat` VALUES (11, 'R&B');
INSERT INTO `songs_cat` VALUES (12, 'Reggae');
INSERT INTO `songs_cat` VALUES (13, 'Rock');
INSERT INTO `songs_cat` VALUES (14, 'Techno');
INSERT INTO `songs_cat` VALUES (15, 'Народни');
INSERT INTO `songs_cat` VALUES (16, 'Кючеци');
INSERT INTO `songs_cat` VALUES (17, 'Хора');
INSERT INTO `songs_cat` VALUES (18, 'Drum''n''Bass');
INSERT INTO `songs_cat` VALUES (19, 'Retro');
INSERT INTO `songs_cat` VALUES (20, 'Гръцко');
INSERT INTO `songs_cat` VALUES (21, 'House');
INSERT INTO `songs_cat` VALUES (22, 'Jungle');
INSERT INTO `songs_cat` VALUES (23, 'Metal');
INSERT INTO `songs_cat` VALUES (24, 'Поп Фолк');
INSERT INTO `songs_cat` VALUES (25, 'Punk');
INSERT INTO `songs_cat` VALUES (26, 'Rap');
INSERT INTO `songs_cat` VALUES (27, 'Reggaeton');
INSERT INTO `songs_cat` VALUES (28, 'Сръбско');
INSERT INTO `songs_cat` VALUES (29, 'Trance');
INSERT INTO `songs_cat` VALUES (30, 'Детски');
INSERT INTO `songs_cat` VALUES (31, 'Други');
8)
Увеличете...

+1 :?: :?: благодаря много


DROP TABLE IF EXISTS `songs_cat`;
CREATE TABLE `songs_cat` (
Увеличете...

Опс... грешка
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе