Results 1 to 2 of 2

Thread: mySQL field list of words

  1. #1
    Join Date
    Feb 2006
    Posts
    106

    mySQL field list of words

    I want to make a system of tags in a gallery php that I developed currently. My problem is that I do not know how I can store these tags as simply and with more optimize option too. Is there a field type mysql store which allows more words separately? Or else what solutions you would suggest? Thank you in advance

  2. #2
    Join Date
    Jun 2006
    Posts
    623
    I'll do here at first glance:
    GALLERY (ID_GALLERY Primary auto_increment, LABEL)
    GALLERY_TO_TAG Table de liaison (ID_GALLERY, ID_TAG)
    TAG (ID_TAG Primary auto_increment, LABEL)
    After the deep left join
    you can also use in (occurence1, occurence2) in your request for selection stitch on several occurrence.
    Have Fun.

Similar Threads

  1. Information and use of macro for search the list of words
    By Farhat007 in forum Windows Software
    Replies: 4
    Last Post: 06-09-2010, 10:56 PM
  2. Populate Text Field Based On Drop-Down List Selection
    By Kaalicharan in forum Software Development
    Replies: 6
    Last Post: 21-07-2010, 09:59 AM
  3. Replies: 3
    Last Post: 19-07-2010, 04:23 PM
  4. Replies: 3
    Last Post: 07-11-2009, 09:36 PM
  5. Sharepoint list calculated field unique ID number
    By NetWorm in forum Software Development
    Replies: 3
    Last Post: 10-06-2009, 08:02 PM

Tags for this Thread

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
  •  
Page generated in 1,717,754,940.95245 seconds with 17 queries