Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Inserting infomation into mysql

2»

Comments

  • #32
    Protype
    Closed Accounts Posts: 73 ✭✭Protype


    eoin wrote: »

    Therefore, if a customer is assigned to three counties, then there will be three rows in that table for the customer.

    when i have this 3rd table, is this something which happens automatically


  • #33
    Adam
    Closed Accounts Posts: 8,866 ✭✭✭Adam


    Protype wrote: »
    You see this is why im confused

    Master table

    Counties

    Jobs

    Master is where i join counties and jobs, do ye understand how
    that's what eoin has been explaining.

    when you submit your form for the customers details, the customers id and the countys id get stored in a database by themselves. there will be a new row for each county that the customer works in, each time you submit the form.


  • #34
    Protype
    Closed Accounts Posts: 73 ✭✭Protype


    in the master table i have the name, surname, address, town, and county_id there is more but im not going to list them all

    i also have a table for county which only has the id and county name

    again i have more tables like this (county) table. i won't list them all

    when i'm inserting new people into the database all goes to the master table
    and now i don't know if i made a mess of my database doing it this way.


  • #35
    Protype
    Closed Accounts Posts: 73 ✭✭Protype


    Sorry for the frustration

    Thanks for the help


Advertisement