Две колонки

[niksdevil]

Cosa, твоя начин не става

 

[ArchangelS]

Дай таблицата

 

[niksdevil]

CREATE TABLE `users` (
  `username` varchar(30) collate utf8_unicode_ci NOT NULL,
  `password` varchar(32) collate utf8_unicode_ci default NULL,
  `userid` varchar(32) collate utf8_unicode_ci default NULL,
  `userlevel` tinyint(1) unsigned NOT NULL,
  `email` varchar(50) collate utf8_unicode_ci default NULL,
  `timestamp` int(11) unsigned NOT NULL,
  `fname` varchar(25) collate utf8_unicode_ci NOT NULL,
  `lname` varchar(25) collate utf8_unicode_ci NOT NULL,
  `sex` varchar(1) collate utf8_unicode_ci NOT NULL,
  `pic` text collate utf8_unicode_ci NOT NULL,
  `city` varchar(50) collate utf8_unicode_ci NOT NULL,
  `points` int(11) NOT NULL,
  `sport` text collate utf8_unicode_ci NOT NULL,
  `movie` text collate utf8_unicode_ci NOT NULL,
  `smoke` text collate utf8_unicode_ci NOT NULL,
  `drink` text collate utf8_unicode_ci NOT NULL,
  `book` text collate utf8_unicode_ci NOT NULL,
  `eyes` text collate utf8_unicode_ci NOT NULL,
  `rast` text collate utf8_unicode_ci NOT NULL,
  `teglo` text collate utf8_unicode_ci NOT NULL,
  `music` text collate utf8_unicode_ci NOT NULL,
  `info` text collate utf8_unicode_ci NOT NULL,
  `day` text collate utf8_unicode_ci NOT NULL,
  `month` text collate utf8_unicode_ci NOT NULL,
  `year` text collate utf8_unicode_ci NOT NULL,
  `age` int(11) NOT NULL,
  `sms` int(11) NOT NULL,
  `av` text collate utf8_unicode_ci NOT NULL,
  `click` int(11) NOT NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

[niksdevil]

Ето я базата данни какво стана ?