Hi everyone, I've just created the structure of a database and am deciding the best way to insert the data. The database includes a number of tables that have foreign keys referencing primary keys in other tables. The application I'm building will make use of the data in one of the following ways (haven't decided yet):
1) The data will be used in a Flash movie and will have an accompanying CMS associated with it, or 2) The data will be used in a Flash movie but won't have a CMS If I decide on a CMS, should I build this first and use the PHP and MySQL to create an interface whereby I can enter the data and have the foreign keys entered in the correct place automatically? Or if I don't go with a CMS and just need to populate the database for use in Flash, what's the most efficient way of doing this? I mean I'm aware I can populate it with a .csv file but this wouldn't take care of inserting the correct foreign key values against the appropriate records. I wouldn't have to manually enter these foreign keys, would I? So does the way you populate a database depend on whether you're using a CMS or not? Have I got the right idea? Any help much appreciated.
