Клипове

Zion каза:
http://web-tourist.net/login/login/view.php?st=2445

Да разгледах го, но нещо немога да наглася категориите да излизат на БГ излизат като " ??? "
пробвах със
Код:
$chars="SET CHARACTER SET cp1251";mysql_query($chars);
въс config.php но пак нестана ? как ще стане :)
 
Използвай този SQL:

Код:
CREATE TABLE `filmi` ( 
`id` mediumint(8) unsigned NOT NULL auto_increment, 
`kategoriq` varchar(255) collate latin1_swedish_ci NOT NULL default '', 
`seriq` char(1) collate latin1_swedish_ci NOT NULL default '', 
`nomer` varchar(10) collate latin1_swedish_ci NOT NULL default '', 
`zaglaviebg` text collate latin1_swedish_ci NOT NULL, 
`zaglavieus` text collate latin1_swedish_ci NOT NULL, 
`poster` text collate latin1_swedish_ci NOT NULL, 
`wreme` text collate latin1_swedish_ci NOT NULL, 
`godina` text collate latin1_swedish_ci NOT NULL, 
`dyrjawa` text collate latin1_swedish_ci NOT NULL, 
`rejis` text collate latin1_swedish_ci NOT NULL, 
`roli` text collate latin1_swedish_ci NOT NULL, 
`link` text collate latin1_swedish_ci NOT NULL, 
`reiting` text collate latin1_swedish_ci NOT NULL, 
`nositel` text collate latin1_swedish_ci NOT NULL, 
`broinositeli` text collate latin1_swedish_ci NOT NULL, 
`rezume` mediumtext collate latin1_swedish_ci NOT NULL, 
`dopylnitelno` mediumtext collate latin1_swedish_ci NOT NULL, 
`c1` smallint(1) unsigned NOT NULL default '0', 
`c2` smallint(1) unsigned NOT NULL default '0', 
`c3` smallint(1) unsigned NOT NULL default '0', 
`c4` smallint(1) unsigned NOT NULL default '0', 
`c5` smallint(1) unsigned NOT NULL default '0', 
`c6` smallint(1) unsigned NOT NULL default '0', 
`c7` smallint(1) unsigned NOT NULL default '0', 
`c8` smallint(1) unsigned NOT NULL default '0', 
`c9` smallint(1) unsigned NOT NULL default '0', 
`c10` smallint(1) unsigned NOT NULL default '0', 
`c11` smallint(1) unsigned NOT NULL default '0', 
`c12` smallint(1) unsigned NOT NULL default '0', 
`c13` smallint(1) unsigned NOT NULL default '0', 
`c14` smallint(1) unsigned NOT NULL default '0', 
`c15` smallint(1) unsigned NOT NULL default '0', 
`c16` smallint(1) unsigned NOT NULL default '0', 
`c17` smallint(1) unsigned NOT NULL default '0', 
`c18` smallint(1) unsigned NOT NULL default '0', 
`c19` smallint(1) unsigned NOT NULL default '0', 
`c20` smallint(1) unsigned NOT NULL default '0', 
`c21` smallint(1) unsigned NOT NULL default '0', 
`c22` smallint(1) unsigned NOT NULL default '0', 
`c23` smallint(1) unsigned NOT NULL default '0', 
`c24` smallint(1) unsigned NOT NULL default '0', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AUTO_INCREMENT=0 ; 

CREATE TABLE `janr` ( 
`id` smallint(5) unsigned NOT NULL auto_increment, 
`name` varchar(60) collate latin1_swedish_ci NOT NULL default '', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AUTO_INCREMENT=25 ; 

INSERT INTO `janr` VALUES(1, 'Комедия'); 
INSERT INTO `janr` VALUES(2, 'Трилър'); 
INSERT INTO `janr` VALUES(3, 'Романтичен'); 
INSERT INTO `janr` VALUES(4, 'Късометражен'); 
INSERT INTO `janr` VALUES(5, 'Ужаси'); 
INSERT INTO `janr` VALUES(6, 'Психо'); 
INSERT INTO `janr` VALUES(7, 'Мистерия'); 
INSERT INTO `janr` VALUES(8, 'Исторически'); 
INSERT INTO `janr` VALUES(9, 'Документален'); 
INSERT INTO `janr` VALUES(10, 'Семеен'); 
INSERT INTO `janr` VALUES(11, 'Приключенски'); 
INSERT INTO `janr` VALUES(12, 'Еротичeн'); 
INSERT INTO `janr` VALUES(13, 'Драма'); 
INSERT INTO `janr` VALUES(14, 'Уестърн'); 
INSERT INTO `janr` VALUES(15, 'Екшън'); 
INSERT INTO `janr` VALUES(16, 'Музикален'); 
INSERT INTO `janr` VALUES(17, 'Криминален'); 
INSERT INTO `janr` VALUES(18, 'Анимация'); 
INSERT INTO `janr` VALUES(19, 'Фантастика'); 
INSERT INTO `janr` VALUES(20, 'Детски'); 
INSERT INTO `janr` VALUES(21, 'Сериал'); 
INSERT INTO `janr` VALUES(22, 'Военен'); 
INSERT INTO `janr` VALUES(23, 'Пародия'); 
INSERT INTO `janr` VALUES(24, 'Друг');

ако пък не ти излзиат наред си ги добави чрез php файл.
но ти излзиат ???? заради колацията понеже е на cp1251_bulgarian_ci ..
и на моят локалхост е така , но когато използвам lati1_swedish_ci си бчка перфектно :>
 
в конфиг.пхп файла сложи mysql_query("SET NAMES cp1251"); след връзката с ДБ :)
 
Може и да няма нужда от това..
Аз не използвам SET NAMES cp1251 и пак излиза наред.
Нека пробва и да каже резултата..
 
proba каза:
Използвай този SQL:

Код:
CREATE TABLE `filmi` ( 
`id` mediumint(8) unsigned NOT NULL auto_increment, 
`kategoriq` varchar(255) collate latin1_swedish_ci NOT NULL default '', 
`seriq` char(1) collate latin1_swedish_ci NOT NULL default '', 
`nomer` varchar(10) collate latin1_swedish_ci NOT NULL default '', 
`zaglaviebg` text collate latin1_swedish_ci NOT NULL, 
`zaglavieus` text collate latin1_swedish_ci NOT NULL, 
`poster` text collate latin1_swedish_ci NOT NULL, 
`wreme` text collate latin1_swedish_ci NOT NULL, 
`godina` text collate latin1_swedish_ci NOT NULL, 
`dyrjawa` text collate latin1_swedish_ci NOT NULL, 
`rejis` text collate latin1_swedish_ci NOT NULL, 
`roli` text collate latin1_swedish_ci NOT NULL, 
`link` text collate latin1_swedish_ci NOT NULL, 
`reiting` text collate latin1_swedish_ci NOT NULL, 
`nositel` text collate latin1_swedish_ci NOT NULL, 
`broinositeli` text collate latin1_swedish_ci NOT NULL, 
`rezume` mediumtext collate latin1_swedish_ci NOT NULL, 
`dopylnitelno` mediumtext collate latin1_swedish_ci NOT NULL, 
`c1` smallint(1) unsigned NOT NULL default '0', 
`c2` smallint(1) unsigned NOT NULL default '0', 
`c3` smallint(1) unsigned NOT NULL default '0', 
`c4` smallint(1) unsigned NOT NULL default '0', 
`c5` smallint(1) unsigned NOT NULL default '0', 
`c6` smallint(1) unsigned NOT NULL default '0', 
`c7` smallint(1) unsigned NOT NULL default '0', 
`c8` smallint(1) unsigned NOT NULL default '0', 
`c9` smallint(1) unsigned NOT NULL default '0', 
`c10` smallint(1) unsigned NOT NULL default '0', 
`c11` smallint(1) unsigned NOT NULL default '0', 
`c12` smallint(1) unsigned NOT NULL default '0', 
`c13` smallint(1) unsigned NOT NULL default '0', 
`c14` smallint(1) unsigned NOT NULL default '0', 
`c15` smallint(1) unsigned NOT NULL default '0', 
`c16` smallint(1) unsigned NOT NULL default '0', 
`c17` smallint(1) unsigned NOT NULL default '0', 
`c18` smallint(1) unsigned NOT NULL default '0', 
`c19` smallint(1) unsigned NOT NULL default '0', 
`c20` smallint(1) unsigned NOT NULL default '0', 
`c21` smallint(1) unsigned NOT NULL default '0', 
`c22` smallint(1) unsigned NOT NULL default '0', 
`c23` smallint(1) unsigned NOT NULL default '0', 
`c24` smallint(1) unsigned NOT NULL default '0', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AUTO_INCREMENT=0 ; 

CREATE TABLE `janr` ( 
`id` smallint(5) unsigned NOT NULL auto_increment, 
`name` varchar(60) collate latin1_swedish_ci NOT NULL default '', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AUTO_INCREMENT=25 ; 

INSERT INTO `janr` VALUES(1, 'Комедия'); 
INSERT INTO `janr` VALUES(2, 'Трилър'); 
INSERT INTO `janr` VALUES(3, 'Романтичен'); 
INSERT INTO `janr` VALUES(4, 'Късометражен'); 
INSERT INTO `janr` VALUES(5, 'Ужаси'); 
INSERT INTO `janr` VALUES(6, 'Психо'); 
INSERT INTO `janr` VALUES(7, 'Мистерия'); 
INSERT INTO `janr` VALUES(8, 'Исторически'); 
INSERT INTO `janr` VALUES(9, 'Документален'); 
INSERT INTO `janr` VALUES(10, 'Семеен'); 
INSERT INTO `janr` VALUES(11, 'Приключенски'); 
INSERT INTO `janr` VALUES(12, 'Еротичeн'); 
INSERT INTO `janr` VALUES(13, 'Драма'); 
INSERT INTO `janr` VALUES(14, 'Уестърн'); 
INSERT INTO `janr` VALUES(15, 'Екшън'); 
INSERT INTO `janr` VALUES(16, 'Музикален'); 
INSERT INTO `janr` VALUES(17, 'Криминален'); 
INSERT INTO `janr` VALUES(18, 'Анимация'); 
INSERT INTO `janr` VALUES(19, 'Фантастика'); 
INSERT INTO `janr` VALUES(20, 'Детски'); 
INSERT INTO `janr` VALUES(21, 'Сериал'); 
INSERT INTO `janr` VALUES(22, 'Военен'); 
INSERT INTO `janr` VALUES(23, 'Пародия'); 
INSERT INTO `janr` VALUES(24, 'Друг');

ако пък не ти излзиат наред си ги добави чрез php файл.
но ти излзиат ???? заради колацията понеже е на cp1251_bulgarian_ci ..
и на моят локалхост е така , но когато използвам lati1_swedish_ci си бчка перфектно :>

Със това нестана ... Сега ще пробвам със предложението на Zion
 
Пробвай и с тази база данни
Код:
CREATE TABLE IF NOT EXISTS `filmi` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`kategoriq` varchar(255) NOT NULL,
`seriq` char(1) NOT NULL,
`nomer` varchar(10) NOT NULL,
`zaglaviebg` text NOT NULL,
`zaglavieus` text NOT NULL,
`poster` text NOT NULL,
`wreme` text NOT NULL,
`godina` text NOT NULL,
`dyrjawa` text NOT NULL,
`rejis` text NOT NULL,
`roli` text NOT NULL,
`link` text NOT NULL,
`reiting` text NOT NULL,
`nositel` text NOT NULL,
`broinositeli` text NOT NULL,
`rezume` mediumtext NOT NULL,
`dopylnitelno` mediumtext NOT NULL,
`c1` smallint(1) unsigned NOT NULL default '0',
`c2` smallint(1) unsigned NOT NULL default '0',
`c3` smallint(1) unsigned NOT NULL default '0',
`c4` smallint(1) unsigned NOT NULL default '0',
`c5` smallint(1) unsigned NOT NULL default '0',
`c6` smallint(1) unsigned NOT NULL default '0',
`c7` smallint(1) unsigned NOT NULL default '0',
`c8` smallint(1) unsigned NOT NULL default '0',
`c9` smallint(1) unsigned NOT NULL default '0',
`c10` smallint(1) unsigned NOT NULL default '0',
`c11` smallint(1) unsigned NOT NULL default '0',
`c12` smallint(1) unsigned NOT NULL default '0',
`c13` smallint(1) unsigned NOT NULL default '0',
`c14` smallint(1) unsigned NOT NULL default '0',
`c15` smallint(1) unsigned NOT NULL default '0',
`c16` smallint(1) unsigned NOT NULL default '0',
`c17` smallint(1) unsigned NOT NULL default '0',
`c18` smallint(1) unsigned NOT NULL default '0',
`c19` smallint(1) unsigned NOT NULL default '0',
`c20` smallint(1) unsigned NOT NULL default '0',
`c21` smallint(1) unsigned NOT NULL default '0',
`c22` smallint(1) unsigned NOT NULL default '0',
`c23` smallint(1) unsigned NOT NULL default '0',
`c24` smallint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `filmi`
--

-- --------------------------------------------------------

--
-- Table structure for table `janr`
--

CREATE TABLE IF NOT EXISTS `janr` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `janr`
--

INSERT INTO `janr` (`id`, `name`) VALUES
(1, 'Комедия'),
(2, 'Трилър'),
(3, 'Романтичен'),
(4, 'Късометражен'),
(5, 'Ужаси'),
(6, 'Психо'),
(7, 'Мистерия'),
(8, 'Исторически'),
(9, 'Документален'),
(10, 'Семеен'),
(11, 'Приключенски'),
(12, 'Еротичен'),
(13, 'Драма'),
(14, 'Уестърн'),
(15, 'Екшън'),
(16, 'Музикален'),
(17, 'Криминален'),
(18, 'Анимация'),
(19, 'Фантастика'),
(20, 'Детски'),
(21, 'Сериал'),
(22, 'Военен'),
(23, 'Пародия'),
(24, 'Друг');
 
Zion каза:
Пробвай и с тази база данни
Код:
CREATE TABLE IF NOT EXISTS `filmi` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`kategoriq` varchar(255) NOT NULL,
`seriq` char(1) NOT NULL,
`nomer` varchar(10) NOT NULL,
`zaglaviebg` text NOT NULL,
`zaglavieus` text NOT NULL,
`poster` text NOT NULL,
`wreme` text NOT NULL,
`godina` text NOT NULL,
`dyrjawa` text NOT NULL,
`rejis` text NOT NULL,
`roli` text NOT NULL,
`link` text NOT NULL,
`reiting` text NOT NULL,
`nositel` text NOT NULL,
`broinositeli` text NOT NULL,
`rezume` mediumtext NOT NULL,
`dopylnitelno` mediumtext NOT NULL,
`c1` smallint(1) unsigned NOT NULL default '0',
`c2` smallint(1) unsigned NOT NULL default '0',
`c3` smallint(1) unsigned NOT NULL default '0',
`c4` smallint(1) unsigned NOT NULL default '0',
`c5` smallint(1) unsigned NOT NULL default '0',
`c6` smallint(1) unsigned NOT NULL default '0',
`c7` smallint(1) unsigned NOT NULL default '0',
`c8` smallint(1) unsigned NOT NULL default '0',
`c9` smallint(1) unsigned NOT NULL default '0',
`c10` smallint(1) unsigned NOT NULL default '0',
`c11` smallint(1) unsigned NOT NULL default '0',
`c12` smallint(1) unsigned NOT NULL default '0',
`c13` smallint(1) unsigned NOT NULL default '0',
`c14` smallint(1) unsigned NOT NULL default '0',
`c15` smallint(1) unsigned NOT NULL default '0',
`c16` smallint(1) unsigned NOT NULL default '0',
`c17` smallint(1) unsigned NOT NULL default '0',
`c18` smallint(1) unsigned NOT NULL default '0',
`c19` smallint(1) unsigned NOT NULL default '0',
`c20` smallint(1) unsigned NOT NULL default '0',
`c21` smallint(1) unsigned NOT NULL default '0',
`c22` smallint(1) unsigned NOT NULL default '0',
`c23` smallint(1) unsigned NOT NULL default '0',
`c24` smallint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `filmi`
--

-- --------------------------------------------------------

--
-- Table structure for table `janr`
--

CREATE TABLE IF NOT EXISTS `janr` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `janr`
--

INSERT INTO `janr` (`id`, `name`) VALUES
(1, 'Комедия'),
(2, 'Трилър'),
(3, 'Романтичен'),
(4, 'Късометражен'),
(5, 'Ужаси'),
(6, 'Психо'),
(7, 'Мистерия'),
(8, 'Исторически'),
(9, 'Документален'),
(10, 'Семеен'),
(11, 'Приключенски'),
(12, 'Еротичен'),
(13, 'Драма'),
(14, 'Уестърн'),
(15, 'Екшън'),
(16, 'Музикален'),
(17, 'Криминален'),
(18, 'Анимация'),
(19, 'Фантастика'),
(20, 'Детски'),
(21, 'Сериал'),
(22, 'Военен'),
(23, 'Пародия'),
(24, 'Друг');


Нестава ... А Колация ми е "cp1251_general_ci"
 
Ами тя колацията ти е такава каквато трябва да е. Незнам просто къде може да е проблема. Я пробвай на някой безплатен хостинг да качиш сайта.
 

Горе