Creatin fields in a table from an array
Posted by peuge (peuge), 28 March 2008I 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,
***** So I need to call in the array $name_array and make those the field names.
Posted by admin (Graham Ellis), 28 March 2008Yes, 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?
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: firstname.lastname@example.org • WEB: http://www.wellho.net • SKYPE: wellho