j8547
asked on
Select Logic and Dates
I have a database the lists jobs, their start dates, admin dates, production dates, ship date and finish date. My webpage display the job name, start date and then the status of the next 5 days. If the data is between start and production then its in Admin stage, between production and before ship date, then in production stage and so on.
It looks like it is working but not all the status is wrong. The logic in the Select looks correct but it is just not working. If i change the select to be (true) which I think it should be then it totally messes it up. I thought I had all the dates formatted the same way but not sure if this is throwing my logic out. I just can't figure it out. Any help appreciated.
Database.jpg
Display.jpg
Index.php
It looks like it is working but not all the status is wrong. The logic in the Select looks correct but it is just not working. If i change the select to be (true) which I think it should be then it totally messes it up. I thought I had all the dates formatted the same way but not sure if this is throwing my logic out. I just can't figure it out. Any help appreciated.
Database.jpg
Display.jpg
Index.php
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.