Generally I would break this up into 2 tables: Record table: > record_id, catagoryid, Text, URL, Disc, Cat
Category table: catagoryId, catagoryName, catagoryDescription but you could also just make category a column on the record table: > record_id, Text, URL, Disc, Cat, Catagory Paul. On Aug 11, 2009, at 10:33 PM, John Barrett wrote: > > Hi, > I am working on a List admin that has a form that write URLs with > data to a db. I am confused on how can I add the category to > multiple area. > I have a form that writes to a DB: > The database has > 1) Site name > 2) url > 3) paragraph about what the site includes > 4) Topic areas to place the site. Most urls will go in multiple areas. > > This is done for one category. Okay maybe having 30 different > versions of the same add/delete/update form is not good practice, > but I am new at this. > > So for example I would have Adobe(http://adobe.com), and a > description about adobe. But I would place adobe in many categories, > such as ColdFusion, Flash, Flex, etc. > > So if I have a table for each page that I want to update, I have 30 > so far, how can I write to multiple tables at the same time? > > The DB structure is: > record_id, Text, URL, Disc, Cat > > Any help would be great, > Thanks so much, > John > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4693 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
