Solarpitch Posted January 28, 2008 Share Posted January 28, 2008 Hey, Just looking for a little help with this. I have a table in my DB that has a date and time column. Bascially it allows an admin to block a date to stop a customer from making a booking. So if I have a list of dates that were blocked, how would I loop through them and check it against the value the customer has entered? Customer enters 28/1/08 Dates Blocked... 27/1/08 28/1/08 02/2/08 05/3/08 message "This date is not available". Quote Link to comment Share on other sites More sharing options...
priti Posted January 28, 2008 Share Posted January 28, 2008 hmmm,, well one thing you can do is convert both dates in timestamp format using mktime() and check if it is equal.If found == then it is blocked and you can show you message. Regards Quote Link to comment Share on other sites More sharing options...
adam291086 Posted January 28, 2008 Share Posted January 28, 2008 if the blocked list is saved in a database. Then try the following 1) select everything from the blocked table 2) use mysql_fetch_array 3) then using foreach($database_array_name as $blocked) { if($blocked == $datefromcustomer) { echo "date not allowed"; } else { update } Quote Link to comment Share on other sites More sharing options...
Solarpitch Posted January 28, 2008 Author Share Posted January 28, 2008 Cheers guys... I'll give it ago after lunch and see how i get on Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.