i seem to be bad at spelling, but...

[ubunreal69]

... can anyone find a problem with this query ?

    mysql_query("create table GDB_poll (p_num int(11) not null,
        type set(‘question’,’title’,’no_of_ques’,’option’,’result’) not null,
        value tinyblob not null,
        extra int(11))") or die ("<br>Error Creating Table 2. Possible reason: table already exists");
    ECHO "$success | GDB_poll table created <br>\n"; 

i think it might be the 'set' thing, but i cant seem to get it working

[scoutt]

yeah I see a problem.

mysql_query("create table GDB_poll (p_num int(11) not null,
type set(‘question’,’title’,’no_of_ques’,’option’,’result’) not null, value tinyblob not null,
extra int(11))") or die ("<br>Error Creating Table 2. Possible reason: table already exists");
ECHO "$success | GDB_poll table created <br>\n";


can't have spaces in the name of the column (I don't think) and you have the name of the column as type set but what is after it? it should be text or varchar(100) or something.

and I think value is a mysql reserved word.

[scoutt]

ahh it is to early in the morning.
type is reserved for mysql, exchange type for the column name.

try this

mysql_query("create table GDB_poll (p_num int(11) not null, 
p_something set('question','title','no_of_ques','option','result') not null, p_value tinyblob not null, 
extra int(11))") or die ("<br>Error Creating Table 2. Possible reason: table already exists"); 
ECHO "$success | GDB_poll table created <br>\n"; 

and why are you using ` instead of ' also I don't think this is what you are after but you can try it.

[ubunreal69]

thanx scoutt, i'll give that a try the minute i have a chance

[ubunreal69]

well, it now works all i did was replace every ` with a ' , dont ask why they were like that in the first place