[RESOLVED] create table with - in name

[qadeer_ahmad]

Hi,
I want to create a table like "table_name-test-ing"
its working nice on local and also on web cpanel but when i try to create this table from dynamic query it give me message that can not create this table.

Can i not create this table from dynamic query or some thing other wrong?

i am using this query
$sql="CREATE TABLE $table_name (
$noun_id int(11) NOT NULL default '0', languages_id varchar(50) NOT NULL default '',

date_added date default NULL, date_last_modified date default NULL, a_te_noun_singular longtext, a_te_noun_plural longtext, a_au_audio_singular varchar(250) default NULL, a_au_audio_plural varchar(250) default NULL, a_au_audio_examples varchar(250) default NULL,

a_te_examples varchar(250) default NULL, b_te_synonyms_id varchar(250) default NULL, PRIMARY KEY ($noun_id,languages_id)
)";

Regards
Qadeer Ahmad Minhas

[leatherback]

What does the mysql_error() say? I think you cannot define two primary keys. I suppose one would be primary key, the other just key.

[qadeer_ahmad]

thanks
my problem is solved only one change here i have to put $table_name as $table_name

Regards