Using Script to create tables...
Posted on 2002-04-22
I am really just learning MySQL and PHP, and also have a project I need to get done with the deadline coming up soon.
The server that hosts the website does not allow me to use a command line, so I think I need to use scripts to create my tables. Andriv offered me the following code in another question:
$dbconnect = mysql_connect("host","user","password");
$Query = "Create table tableName (prodid int(10) not null auto_increment,next field,next field)";
My question is, what do I surround the code with? HTML? PHP?
If PHP I would assume it would look like the following:
code from Andriv, to build table and columns
Then would I need an HTML form to run the PHP, like this?
<form action="xxxx.php" method=post>
<td colspan=2 align=center><input type=submit value="Submit Order"></td>
I really appreciate the help.