Why does one work and not the other?

[darenpaul]

Can some body tell me why this wont create a new table:

1 $table=uniqid();
2 $createtab = "create table $table(
3 QuestionID varchar(20) NOT NULL,
4 Question char(255),
5 DBAnswer char(255),
6 UserAnswer char(255),
7 primary key(QuestionID) )";
8 $result= mysql_query($createtab, $connection);

but this will:

1 $createtab = "create table test(
2 QuestionID varchar(20) NOT NULL,
3 Question char(255),
4 DBAnswer char(255),
5 UserAnswer char(255),
6 primary key(QuestionID) )";
7 $result= mysql_query($createtab, $connection);

The only difference being line 2!!!!!!

[nnichols]

I suggest you

echo $table;

and see if your "uniqid()" function is returning what you expect.

[darenpaul]

Thanks for your help - I resolved this by putting some text in like;

$table=uniqid("test");

for some reason this creates a unique ID after the word test but does not create anything if you don't!

Can anyone explain why?

Just out of curiosity!!!

Cheers

[nnichols]

This is because uniqid() must be passed a prefix even if it is an empty string -

$table=uniqid(); //not ok

$table=uniqid(''); //ok

Hope this helps 😉

[darenpaul]

Thanks for helping me on this - it is has really helped!!!!