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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php