fail to build innodb table

[orange08]

hi, in my local pc, my code that create table with innodb engine is work properly. but, when i use the same piece of code in my web hosting to create the table...table is created with MyISAM...

 

so, can i know what's the problem here and how to solve it?

 

$tbl = "CREATE TABLE IF NOT EXISTS mytable(
tbl_id varchar(10),
user_name varchar(20),
PRIMARY KEY (tbl_id),
KEY search_tbl(tbl_id,user_name)

)ENGINE=INNODB";

[Mchl]

http://dev.mysql.com/doc/refman/5.0/en/show-engines.html

 

I'm guessing InnoDB is disabled on your host.

[orange08]

http://dev.mysql.com/doc/refman/5.0/en/show-engines.html

 

I'm guessing InnoDB is disabled on your host.

 

wah, if like that then it's a problem for me...