Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    55

    Unanswered: add multiple values to a field (was "New at this, probably easy answer..")

    I'm trying to add multiple values from a drop down list to a field in mysql.
    The originating data is from another table of the same database.
    I'd like to be able to (by "ctrl + click") select more that one of these from the list and add them to a single field within a file. I've got a few books and have done some online research on this but to no avail, is this possible in MySQL????
    Edit: BTW. I'm using Dreamweaver MX 2004 as a web editor if that helps, and I've been able to make multiple selections with a tool option in the application, but only the first of the selected options is what's added in the MySQL field.

    Thanks,
    Ray
    Attached Thumbnails Attached Thumbnails multiple.JPG  
    Last edited by purpendicular; 01-25-05 at 16:00. Reason: to add more background info

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    adding multiple values to a field is not a good idea

    adding multiple rows, with one value per field, that's fine
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2004
    Posts
    55
    so what's the best way to go about this?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    add multiple rows, one for every value in the dropdown list
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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