PHP how to update database?
Posted: Fri Apr 25, 2008 12:39 am
I dont know what to put in my subject because I dont know how to categorize my question. I need people's suggestions on how will I do this...
I have managed to compare the current dates and expiration dates of records. When they fill up a form I have this expiration question thingy so there. I was able to store in my database if the product is still OK or not OK. I used the timestamps thingy to do compare current date and expiration date...( the strtotime() )...
but then how would the database know if it is still OK the next day? when someone created a profile for example it is not expired today (so it is flagged OK in the database) but tomorrow it will be expired (so it should be flagged "NOT OK").
how can I update the database?
I have managed to compare the current dates and expiration dates of records. When they fill up a form I have this expiration question thingy so there. I was able to store in my database if the product is still OK or not OK. I used the timestamps thingy to do compare current date and expiration date...( the strtotime() )...
but then how would the database know if it is still OK the next day? when someone created a profile for example it is not expired today (so it is flagged OK in the database) but tomorrow it will be expired (so it should be flagged "NOT OK").
how can I update the database?