Design Question

["Daren Cotter" <mysql@xxxxxxxxxxxxxxxx>]

I have a question about a theoretical design to make this work. I have
categories, and things will be listed under these categories. Database
structure is simple: two tables, one for the categories, one for the
listings. Trouble is, some programs need to be listed under more than one
cateogry. I know one way to do this would be to just add that listing to the
listings table twice with a separate category_id each time, but I'd rather
not do it this way. I'm thinking I'll want to use the "set" data type. Can
anyone give me some advice as to how to do this?

TIA,


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60870@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php