will not create more than 2 tables via PHP script, but does on PHPmyAdmin.

[cooldudekyle]

I have a query will run more than 1 statement at a time.
My SQL isbe:

CREATE TABLE `homepage` ( `content1` longtext, `content2` longtext, `content3` longtext, `title` varchar(100) default NULL, `style` varchar(10) default NULL, `use_homepage_control` char(1) default NULL, `s4` tinyint(4) default NULL, `s5` tinyint(4) NOT NULL default '0', PRIMARY KEY (`s5`) ) TYPE=MyISAM; CREATE TABLE `homepage_style` ( `style_id` tinyint(4) NOT NULL auto_increment, `style_name` char(10) default NULL, `style_description` char(250) default NULL, `s1` tinyint(4) default NULL, `s2` tinyint(4) default NULL, `s3` tinyint(4) default NULL, PRIMARY KEY (`style_id`) ) TYPE=MyISAM;

However this does not work when I use my PHP script to run the query. If I just have one create table then it works.
However when I run the complete SQL through PHPmyAdmin it works and generates both tables.

Any ideas?

[longneck]

mysql_query() sends an unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier .

.

[cooldudekyle]

Is there any other way to do it?

[longneck]

run mysql_query() twice?

[cooldudekyle]

I have a whole database with 2,000 queries to insert a new database.

I've done it by using PHP to break apart the different queries and ran each query separatly.

Thanks for your advice.

[Dr John]

You have two thousand tables??? Or are you including the records in this set of queries as well?

[cooldudekyle]

This includes the insert statements! There is not 2000 tables!