Results 1 to 2 of 2
Thread: not sure on this database design
Apr 20, 2004, 12:12 #1
not sure on this database design
I am trying to make this content management site and I am a little unsure about the database design.
I have one table called menu.
I thought next would be menu_display
this would allow for 2 different pages to display these items on but allow the data from them to be edited at the same content page.
Next I figured menu_order
here I am not sure because I need a way to sort the records so that if the newest item sould go first or just to move things around
and I figured some way to make different categories like salads, sandwiches, desserts etc. and just figured I would reference this number in the menu table.
Ok there is the background.
My main question is how do I get the id_main columns to be the same as the id column from the menu table. I know i would use a join but does that mean that I will have to use a join on each query? Jut a little unsure on some of this stuff it is kind of new to me. Is this even the way to go with the tables or should this all be one or maybe two large tables.
Apr 20, 2004, 20:33 #2
Originally Posted by rodin7
- Join Date
- Apr 2004
- 0 Post(s)
- 0 Thread(s)