SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict The Mog's Avatar
    Join Date
    Dec 2002
    Location
    Manchester UK
    Posts
    310
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question CSV Mysql Update

    hi all,

    what i am trying to achieve to no avail is the following

    I export values from a mysql db into CSV format for quick updates and that works fine..

    www.xarex.com/jantar/admin/pick_csv.php

    but as you can see from the page you can select the options that you want to d/l
    I am going to make ID compulsary but its not necessary fro the time being,

    The problem that i am having is with the update mysql feature
    what i need to happen is the first line of the csv is the headings (db field names)
    so that when i do the update it only updates the fields that were choosen on the pick_csv page.
    now i will have no way of knowing before hand what fields will be choosen so i will have to create the update mysql query on the fly,

    I hope this is clear enough

    any help will be great

    K-

  2. #2
    SitePoint Addict The Mog's Avatar
    Join Date
    Dec 2002
    Location
    Manchester UK
    Posts
    310
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    bump

  3. #3
    SitePoint Zealot
    Join Date
    Apr 2004
    Location
    Michigan
    Posts
    140
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Couple of ideas...

    1. Have you considered putting the non-requested data into 'hidden' columns? Then when updating the database from the 'excel csv' file you will have all records at hand.

    2. rather than csv file, perhaps a form with the non-requested data in hidden fields?

    just an old mind meandering...

    Lite...

  4. #4
    SitePoint Addict The Mog's Avatar
    Join Date
    Dec 2002
    Location
    Manchester UK
    Posts
    310
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The problem with this is ....

    I need it to be a csv file so thet the clients can alter multiple records in a very short space of time, being in the computer industry the prices of componants change on a daily bases and if there are 100's of records this can create a problem from a web interface.

    The web interface is already built and is working fine, now i just need to complete this section.

    Back to the proverbial drawing board i suppose

    K-


Bookmarks

Posting Permissions

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