Mam zapytanie:
CREATE TABLE `".$_SESSION['DataBase']['Prefix']."gallery` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`addtime` int(14) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
CREATE TABLE `".$_SESSION['DataBase']['Prefix']."guestbook` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`author` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`body` text NOT NULL,
`addtime` int(14) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
CREATE TABLE `".$_SESSION['DataBase']['Prefix']."help` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`surname` varchar(64) NOT NULL,
`help` text,
`addtime` int(14) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
CREATE TABLE `".$_SESSION['DataBase']['Prefix']."pages` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`content` longtext NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
w $_SESSION['DataBase']['Prefix'] jest przechowywany prefix (np.: cms_ )
zapytanie wywala mi error:
Cytat
Something is wrong in your syntax obok '; CREATE TABLE `cms_guestbook` ( `id` int(10) unsigned NOT' w linii 7
szukam - szukam tego bledu ale znalesc nie moge :/
jakies sugestie?
EDIT:
juz sobie poradzilem...
Ten post edytował Crozin 25.09.2006, 19:29:21