Help with putting a solution together
Posted: Tue Oct 14, 2008 9:25 pm
Hi,
I currently have an application that provides users with 4 different menus on four different pages with each menu containing 7 options. All menus are stored in database which enables content to be changed by site administrator. However a new menu is added every week. This should be added as the first menu with the next menu then becoming the previous first menu and the next menu becoming the previous second and the next menu becoming the previous third. This is the solution I want to achieve but do not currently have. The current process requires the site admin to update each meal in every menu every week meaning they have to change 28 different options which isn't very efficent when it should be only one. In the database at the moment I just have four unrelated tables and simply let the site admin directly update these. Hope I have explained this well. Any suggestions as to how to put together an efficent solution would be a fantastic help. I can provide my current code if its a help.
Thanks
I currently have an application that provides users with 4 different menus on four different pages with each menu containing 7 options. All menus are stored in database which enables content to be changed by site administrator. However a new menu is added every week. This should be added as the first menu with the next menu then becoming the previous first menu and the next menu becoming the previous second and the next menu becoming the previous third. This is the solution I want to achieve but do not currently have. The current process requires the site admin to update each meal in every menu every week meaning they have to change 28 different options which isn't very efficent when it should be only one. In the database at the moment I just have four unrelated tables and simply let the site admin directly update these. Hope I have explained this well. Any suggestions as to how to put together an efficent solution would be a fantastic help. I can provide my current code if its a help.
Thanks