sac8513
01-14-2007, 03:45 AM
I need to create a database that holds a particular stores opening and closing times for each day of the week.
The troule is that the code I am using searches for the store name, open time, and close time through each of those fields. By adding in 7 days means that I essentially need opening and closing times for every day.
I cannot figure out how to put all of this into one table, or even 2 and have my code interpret each store's appropriate information.
I figure if I create a table for every store I have (currently 40) this would be quite time consuming.
Any ideas?
Thanks
The troule is that the code I am using searches for the store name, open time, and close time through each of those fields. By adding in 7 days means that I essentially need opening and closing times for every day.
I cannot figure out how to put all of this into one table, or even 2 and have my code interpret each store's appropriate information.
I figure if I create a table for every store I have (currently 40) this would be quite time consuming.
Any ideas?
Thanks