Re: My First Database + some
Sounds good to me... except I'd change "maybe a unique ID" to "definately a unique ID".
Most menus I see (and especially their inserts) could be made with HTML but if you have quality graphics or something you'd want to use... give it a shot.
You have to add a special module to create pdfs... make sure your host has it or you can install it if you are going to try.
The Ultimate Specials tracker evolves...
Ok I just came up with another issue. Just to keep u guys updated, I am now planning on creating three tables, one for specials, one for categories, and a lookup table to link both of these together.
I just found out today that i have to track specials for the night menu aswell, which is different.
Should I create a new night specials table and another lookup table, or should i store the night menu items in the original specials table? If doing it this way i guess i'd have to specify wether a special was a night special or a day special. Which is the best solution though?
I am also planning on having a menu_order column for each special so that users can reorganise the order special print in after having entered them. How does that sound?
Thanks again! :D