Re: [PHP] Categories like wordpress

> Is this how its done or am I barking up the wrong tree?

You have multiple options:

1. Fully normalised, where you have three tables - one for your
    "articles", one for your categories and a link table.
2. A "SET" MySQL datatype which will allow upto 32 predefined
    categories.
3. A simple CHAR type with the category names, (or if you use numeric
    IDs, you could have many more categories).

The former is, IIRC, faster, but more work to implement. Whereas the 
latter two are very fast to implement but somewhat slower to query. For 
the last two cases the MySQL function FIND_IN_SET() will be very useful.

-- 
Richard Heyes

+----------------------------------------+
| Access SSH with a Windows mapped drive |
|    http://www.phpguru.org/sftpdrive    |
+----------------------------------------+