Search:

Type: Posts; User: wwwfilmfilercom

Search: Search took 0.10 seconds.

  1. Replies
    7
    Views
    976

    Re: Structuring client data

    eg.

    Business|Categories|
    Mr Smith|1;2;3|
    Mr Williams|3|
    Mr Jackson|1;2|

    And then on import I will load the Categories into an array using ; as a delimiter and then add each category number...
  2. Replies
    7
    Views
    976

    Re: Structuring client data

    Thanks for that - it's normalising the database isn't it? And to be fair I do want to do this properly but as you say it's not possible to set up the 3 tables you specify from one CSV file, that's...
  3. Replies
    7
    Views
    976

    Re: Structuring client data

    I think the above is true; so what would be the best way to import the data into mysql? As per my original post I would have thought a CSV file from Excel.

    However, whatever method I choose needs...
  4. Replies
    7
    Views
    976

    Structuring client data

    My client has a number of businesses who cater to a variety of categories and I need to be able to search on these.

    My first thought was to create a mysql database for the businesses and...
Results 1 to 4 of 4



Click Here to Expand Forum to Full Width