Dynamic Categories

[pugs421]

I'm making a site where users will be able to post articles that they write. I would like to set it up where they could add there article to the existing categories, or add it to a new category that they create. I believe I have my table set up correctly for this to work, but I can't figure out how to get it to display they way I that I would like:

 

Democratic Politics

dem article 1

dem article 2

 

Republican Politics

rep article 1

rep article 2

 

Foreign Politics

foreign politics article

 

 

I currently have two tables for this part of the application. Categories and Articles.

Categories has 2 columns, a UniqueID and the category. Users can add a new category which of course generates a new UniqueID.

 

In the Article Table, I have a CategoryValue column, so when a user selects what category they want to post there article in, the entry in the Article table gets assigned the correct CategoryValue.

 

example of Article Table entry

 

UniqueID | Article | Category Value | PostedBy

 

345 ... |Dem Article|1 ..... | .... admin

 

 

I think I have everything set up correctly up until this point. I'm somewhat at a loss now because I haven't been able to manipulate Dreamwever to output my information in the

 

Category

---Article

 

Category2

---Article

 

format that I would like.

 

I have been successfull up until this point in using DW almost entirely for member sites like this(aside from writing some minor conditional statments). I'm starting to think I need to 'hand code' this part of the application. I went back to my PHP books to try to figure out how to accomplish this goal, but it seems like this is a little more advanced than curriculum of my "for Dummies" book . If anyone has any suggestions it would be greatly appreciated. Thanks