[SOLVED] Create a table in mySQL from a .php file

[5pence]

Hi Guys,

 

Is it possible to create a mySQL table from a .php file?

 

If so how?

 

Thanks

 

[jguy]

YES!!!!!!!!!!!

 

something like:

$sql = "CREATE TABLE mytable(
partno CHAR(10) NOT NULL,
descript CHAR(60) NOT NULL,
cost DOUBLE(10,5) NOT NULL, 
user CHAR(15) NOT NULL,
modelno CHAR(20) NOT NULL,
PRIMARY KEY(partno))"; 

$result = MYSQL_QUERY($sql) or die 
("Invalid create");

[5pence]

Thankyou very much indeed