[Kevorkian]

Today at 12:43 PM trafix said this in Post #14
this works,

CREATE TABLE `banneradmin` (
`event` smallint(5) unsigned NOT NULL auto_increment,
`storehack` SMALLINT(6) DEFAULT 0 NOT NULL,
`storecredit` smallint(5) DEFAULT 0 NOT NULL,
`serverpath` varchar(100) NOT NULL,
`guestsfromserver` smallint(5) DEFAULT 0 NOT NULL,
`guestsspecial` smallint(5) DEFAULT 0 NOT NULL,
`alttext` varchar(100) NOT NULL,
`linktext` varchar(100) NOT NULL,
`bannerimg` varchar(100) NOT NULL,
`welcometext` mediumtext NOT NULL,
`guestclicks` smallint(6) DEFAULT 0 NOT NULL,
`membersfromserver` smallint(5) DEFAULT 1 NOT NULL,
`membersspecial` smallint(5) DEFAULT 1 NOT NULL,
`memberalttext` varchar(100) NOT NULL,
`membersclicks` smallint(5) DEFAULT 0 NOT NULL,
PRIMARY KEY (`event`))

whoever i might ask Lesane if he could do one of his doqury.php adding scripts for me....I am still learning, sorry

no, don't work

Errore

query SQL :

CREATE TABLE `banneradmin` (

`event` smallint( 5 ) unsigned NOT NULL auto_increment,
`storehack` SMALLINT( 6 ) DEFAULT0 NOT NULL ,
`storecredit` smallint( 5 ) DEFAULT0 NOT NULL ,
`serverpath` varchar( 100 ) NOT NULL ,
`guestsfromserver` smallint( 5 ) DEFAULT0 NOT NULL ,
`guestsspecial` smallint( 5 ) DEFAULT0 NOT NULL ,
`alttext` varchar( 100 ) NOT NULL ,
`linktext` varchar( 100 ) NOT NULL ,
`bannerimg` varchar( 100 ) NOT NULL ,
`welcometext` mediumtext NOT NULL ,
`guestclicks` smallint( 6 ) DEFAULT0 NOT NULL ,
`membersfromserver` smallint( 5 ) DEFAULT1 NOT NULL ,
`membersspecial` smallint( 5 ) DEFAULT1 NOT NULL ,
`memberalttext` varchar( 100 ) NOT NULL ,
`membersclicks` smallint( 5 ) DEFAULT0 NOT NULL ,
PRIMARY KEY ( `event` )
)

Messaggio di MySQL:


You have an error in your SQL syntax near 'DEFAULT0 NOT NULL , `storecredit` smallint( 5 ) DEFAULT0 NOT NULL , `server' at line 1
Indietro