I'll be using this code for a timepicker so businesses can select their hours of business for each day of the week:
<input name="time" value="" />
I need to know the best way to structure this in the ClientAdverts table: i.e. how best to store the business opening and closing hours from Monday - Sunday.
Can this be done in one field? E.g. An 'OpenHours' field containing all the open and close times from Monday - Sunday for each business listing?
The the data will need to be listed separately/vertically for each day of the week, e.g:
Monday: 08.30 - 17.30
Tuesday: 08.30 - 17.30
Some help and suggestions would be great.