creating table in mysql

[erokar]

I'm having trouble creating a new table. Here's the code (using PEAR DB API):

$db->query("CREATE TABLE host_name.user (user_name char(24) NOT NULL PRIMARY KEY, user_email char(255), user_telephone int, user_invite_mode char(255))";

Error message: Unknown error.

Is it not possible to create tables thorough PHP?

[laserlight]

I believe that table names may not have periods within them.

This would be especially so since host_name.user could then refer to both the "user" column within the "host_name" table and to the "host_name.user" table.

[erokar]

my mistake: i meant db_name.user.

i've tried only user also - this is not the problem

[9mm]

I'm gonna agree with laser and say it's the '.' in the table name. as for the rest I'm not sure since I don't know the PEAR API that well. That or who knows maybe the account your using to access mysql doesn't have the proper creds to create a table. <shrug>