Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[Adeva]

Salut am si eu nevoie de ceva ajutor incerc sa fac un tabel in baza de date si nu reusesc motivul comansa sql are o eroare :"MySQL zice:


You have an error in your SQL syntax near 'DEFAULT0, clicks INT( 10 ) DEFAULT0, active ENUM( 'T', 'F' ) NOT NULL DEFA' at line 1

"

Tabela arata cam asa

CREATE TABLE banner(
ID VARCHAR(32) NOT NULL PRIMARY KEY,
HREF VARCHAR(255) NOT NULL,
SRC VARCHAR(255) NOT NULL,
ALT VARCHAR(255),
hits INT(10) DEFAULT 0,
clicks INT(10) DEFAULT 0,
active ENUM('T', 'F') NOT NULL DEFAULT ' T ',
pos ENUM('A', ''),
b_order INT(10) NOT NULL DEFAULT 1);

nu pot sa imi dau seama unde este eroare :(
daca cineva este binevoitor sa ma ajute si pe mine ii ramin dator ...

Multumesc !

[Constantin]

CREATE TABLE banner1 (
ID varchar(32) NOT NULL default '',
HREF varchar(255) NOT NULL default '',
SRC varchar(255) NOT NULL default '',
ALT varchar(255) default NULL,
hits int(10) default '0',
clicks int(10) default '0',
active enum('T','F') NOT NULL default 'T',
pos enum('A','') default NULL,
b_order int(10) NOT NULL default '1')

[Adeva]

Iti multumesc frumos .... nu ma puteam descurca singur .

[PHPRomania Bot]