Categories like wordpress
| From: | Ryan S | Date: | Thu, 01 May 2008 13:23:34 +0000 |
| Subject: | Categories like wordpress | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-273775@lists.php.net to get a copy of this message | ||
Hey!
Heres what i have to do, upload pics and each pic can be a part of x number of categores
for example:
A picture of a rose can be for birthday, as well as anniversary, or miss you, or love etc
exactly the same as how in wordpress an article can be in multiple categories like tech, current
news, gadgets etc
Was wondering how to do this, and please tell me if I am on the wrong path but:
in the mysql db next to img name have a field called cate (or whatever for categories) and have a
comma seperated list for each of the categories that the pic falls into and then do a mySql LIKE
'%$param%' search if the user wants 'birthday'?
Is this how its done or am I barking up the wrong tree?
TIA
/R
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ