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(
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

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 www.opentalk.org.uk 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., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho