Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Creatin fields in a table from an array

Posted by peuge (peuge), 28 March 2008
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(
***** So I need to call in the array $name_array and make those the field names.


Posted by admin (Graham Ellis), 28 March 2008
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?

This page is a thread posted to the opentalk forum at and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2015: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: • WEB: • SKYPE: wellho