Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 01-09-2008
Member
 
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
Reply With Quote
  #2  
Old 01-09-2008
Member
 
Join Date: Jun 2006
Posts: 620
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "mySQL field list of words"
Thread Thread Starter Forum Replies Last Post
Information and use of macro for search the list of words Farhat007 Windows Software 4 06-09-2010 10:56 PM
Populate Text Field Based On Drop-Down List Selection Kaalicharan Software Development 6 21-07-2010 09:59 AM
PHP - I want to retrieve records from specific field from a MySQL table and build array using PHP bond007dev Software Development 3 19-07-2010 04:23 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
Sharepoint list calculated field unique ID number NetWorm Software Development 3 10-06-2009 08:02 PM


All times are GMT +5.5. The time now is 11:12 AM.