Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Posts
    2

    Question Unanswered: Inputting data across multiple tables..

    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.

  2. #2
    Join Date
    Jul 2004
    Posts
    62
    Do you code from PHP or using LOAD DATA

  3. #3
    Join Date
    Aug 2006
    Posts
    2

    Coding

    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

  4. #4
    Join Date
    Jul 2004
    Posts
    62
    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,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •