This is identical to what I used to create the first table, but the table does not get created (verified using PHPmyadmin). I suspect the code is not good code, but i am using it to learn, so don't worry about my feelings if it is a mess.

SpacePhoenix
—
2011-07-09T21:33:05Z —
#2

Have both tables that you're trying to create got different names? I tried the create table query locally and the table created fine.

CSU_Bill
—
2011-07-10T00:43:32Z —
#3

WOW! I just found the error. There is a stray ) in the code. Once I removed that ) I was able to create the table.

I also realized that the code I posted above is for table one, which worked.

My bad.

CSU_Bill
—
2011-07-10T00:22:07Z —
#4

Yes, both tables have different names. Is it necessary to have completely unique table names. The actual names I used were group_one and group_two. Would this make a difference?

r937
—
2011-07-10T00:34:26Z —
#5

CSU_Bill said:

Would this make a difference?

nope

and you're saying that other than the table name, the tables are identical? or are you saying that the php you used is identical, but the tables have different columns?

may i ask why you're even using php to create tables? it's not as though you were planning on creating tables over and over again (i hope)