|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
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
| |||
| |||
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. |
![]() |
|
Tags: field, mysql, words |
Thread Tools | Search this Thread |
|
![]() | ||||
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 |