Hi all
I am trying to build a data base that holds the details of tattoo studios so that pple can search for. If I split the details down into different table I dont understand how to input data int the table.
I have multiple tables for:
CONTINENTS
COUNTRIES
ADDRESS

Basically for any given address there is a country in a continent, multiple addresses appear in the same country etc. I have read that if information is repeated then put it into its own table. When it comes to putting data into the DB how do I select pre filled details from another table. I have read loads of pages from the web and a few books but cannot find what I need to know. Hope someone can help me.

Do you code from PHP or using LOAD DATA

I am wanting to input data via PHP from a web page but also have specific data pre entered so the user can select from.

Many thanks
VoodooJai

Greetings
In your PHP code just a sample from code before

$db = new sql_db(db_host, db_user, db_password, db_name,false);

$result1 = $db->sql_query($sql_insertinto_table1);
$result2 = $db->sql_query($sql_insertinto_table2);
$result3 = $db->sql_query($sql_insertinto_table3);

Does this meet your requirement,