On Tuesday 21 June 2005 10:35 pm, Dan Fulbright wrote:
> > I have no problem creating a table, using a query from my dbase table 
> > "news":
> >
> > SELECT * FROM table where column = VALUE.
> >
> > However, now that most of our articles have more than one column type
> > (i.e. instead of just technology, the column can now contain "technology,
> > politics, local".
>
> You need to normalize your tables. Make a table called columntypes, then
> another called articlecolumntypes. If you have an article with ID 456,
> and it has column types of technology (ID 5), politics (ID 15), and
> local (ID 34), you tie the articles table to the columntypes table using
> the articlecolumntypes table:

Good point, this would be the 'Proper' way to do it. 

-Micah 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to