I have called in an array of field names entered in a from from a form in the previous php page. with these names I want to create a table with these fields in the database which has already been selected. The thing is these names could be different for each time I create a new table so I need to use these names from the array. Can I do this in the CREATE TABLE?

$name_array = $_POST['fieldname'];
$tname = $_POST['tname'];


mysql_query("CREATE TABLE $tname(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
***** So I need to call in the array $name_array and make those the field names.



Thanks

Yes, there's no reason why you can't do this except I question the design approach; why are you creating different tables - shoud you be using joins instead?

---