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
