[SOLVED] execution of simultaneous mysql query using php

[starrylitgal]

hi!

i m having problem executing two queries together through my PHP code.

Following is the code:

$q1="CREATE TABLE `db`.`tb1`(`col1` tinyint(12),`col2` varchar(12)); 
CREATE TABLE `db`.`tb2` (`col1` int(12),`col2` varchar(12))";
mysql_query($q1) or die(mysql_error());

 

Is there nething wrong?

This query is working properly when executed using phpmyadmin....

it always shows the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `db`.`tb2` at line 2'

 

i tried to run it individually i.e. create these 2 tables (thru php code) separately  like this :

mysql_query($q1);
mysql_query($q2);

 

[$q2 being the second create table statement]

and it successfully executed...

 

but im not able to do it simultaneously in one query....wht is wrong???

 

i m not willing to run it separately coz i hav almost 28 queries to run and it wud mean running 28 queries separately....it wud be a long code...n as per my requirement i hav to chk its status of success for other operations...so..

 

plz does ne1 hav ne solution to this problem..!

 

thnx!

[PFMaBiSmAd]

From the php manual -

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

[starrylitgal]

ok..thnx...

but then how do i solve this problem??

is there any other function which accepts multiple queries and executes them?

[fenway]

ok..thnx...

but then how do i solve this problem??

is there any other function which accepts any multiple queries?

Why do you need such a function? Simply split the string to parts and run a for loop....

[starrylitgal]

hey thnx...

i'll try that...

 

thnx again!