UName10
asked on
Business Open and Close hours for each day of the week - how best to structure in the database using ASP and javascript
I'll be using this code for a timepicker so businesses can select their hours of business for each day of the week:
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
Sunday: Closed
Etc.
Some help and suggestions would be great.
<input name="time" value="" />
<script type="text/javascript">
$(document).ready(function(){
$('input[name="time"]').ptTimeSelect();
});
</script>
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
Sunday: Closed
Etc.
Some help and suggestions would be great.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.