Hi, I have a little problem here. I have a database of Organizations with Operation Hours in this format.
mon_open = X;
mon_close = X;
...
Sun_open = X;
Sun_close = X;
And X are 24 Hours, Closed, 12:00 AM, 1:00 AM, ... , 11:00PM
Now I need to have a way to search for Organizations that are open the time I started my search without inputing the time and without have a time as a hidden value in my html.pl.
I don't know if I am stating this clearly, but someone please help.
I want to have a button in my search form that states "Open Now?" and when I click on it and search. I want it to search the database for all the Organizations that are opened at the time the search was started. I do not want to embed this in the html because if I leave the page open for a hour and than click on it, it would be a hour late. So in another word, I need the time search done on processing time.
Thank you so much.
Scott Wang
mon_open = X;
mon_close = X;
...
Sun_open = X;
Sun_close = X;
And X are 24 Hours, Closed, 12:00 AM, 1:00 AM, ... , 11:00PM
Now I need to have a way to search for Organizations that are open the time I started my search without inputing the time and without have a time as a hidden value in my html.pl.
I don't know if I am stating this clearly, but someone please help.
I want to have a button in my search form that states "Open Now?" and when I click on it and search. I want it to search the database for all the Organizations that are opened at the time the search was started. I do not want to embed this in the html because if I leave the page open for a hour and than click on it, it would be a hour late. So in another word, I need the time search done on processing time.
Thank you so much.
Scott Wang