mysql table

Anon

Hello, I am trying to create a table in a mysql database from a web page using php. In other words, I want to be able to loop in php in order to create multiple tables in my db instead of manually adding in all the tables. Is this possible in php? Is there a command that creates a table in mysql.

I am using solaris running on an apache server. I have tried some variations in my php file like: CREATE TABLE pet(name VARCHAR(20));
and nothing seems to work. I am getting a parse error on that line. Can you help??

Anon

Please see the MySQL documentation on the CREATE TABLE syntax:

http://www.mysql.com/doc/C/R/CREATE_TABLE.html

Best Regards,

Jon

Anon

Hello

Heres the thing u want

assuming u are connected to mysql.

$sql1="create table mandar (name varchar(20);
$sql2="create table mandar (name1 varchar(20);

$queryArr=array("$sql1","$sql2");
foreach($queryArr as $values){
@($values);
}

Cheers this will work for You.
If possible mail me with feedback.

Mandar Kelkar