pls help.....how to?
Posted: Mon Apr 19, 2004 6:40 am
hi guys,
running into a problem. hope somebody can help.
i want to reserve a book. but dat reservation will be activated only for 15 hours.
So, i gave the call_no from the form and it reserve the book under the member name who supplied that call_no and his ID.
i wrote a script that find out the 15 hours from the time when the reservation made and save that time in the reservation time along with the call_no.
but i am just not sure how to inactivate that reservation after 15 hours?
When i run a php script i know i can check the column value and i can easily make the reservation inactivated.
but in this case when i m not about to run any php script but still wnt to see the reservation gets inactivated after the stipulated time, i aint got a clue how to do this.
can anybody give me any tips, idea?
shoudl i use any mysql specific funciton?
pls help
running into a problem. hope somebody can help.
i want to reserve a book. but dat reservation will be activated only for 15 hours.
So, i gave the call_no from the form and it reserve the book under the member name who supplied that call_no and his ID.
i wrote a script that find out the 15 hours from the time when the reservation made and save that time in the reservation time along with the call_no.
but i am just not sure how to inactivate that reservation after 15 hours?
When i run a php script i know i can check the column value and i can easily make the reservation inactivated.
but in this case when i m not about to run any php script but still wnt to see the reservation gets inactivated after the stipulated time, i aint got a clue how to do this.
can anybody give me any tips, idea?
shoudl i use any mysql specific funciton?
pls help