I hope you can help me with this one, and I will try to explain myself best as I can.
I’m building a Pilot Logbook website. I use PHP and MySQL.
DB name: logbook
Table name: air_flight_log
Columns: DEPARTURE_DATE, BLOCK_TIME_START, BLOCK_TIME_END, TOTAL_BLOCKTIME.
- I need to calculate the different between BLOCK_TIME_START - BLOCK_TIME_END and display the time on the “TOTAL_BLOCKTIME” as HH:MM.
- Need to make sure to calculate the right time if I enter 23:00 - 01:00 the day after.
- I need to do a Record count for the whole “TOTAL_BLOCKTIME” columns as HH:MM.
- What “Type” shell I use for the BLOCK_TIME_START, BLOCK_TIME_END, TOTAL_BLOCKTIME in my Data Base, a TIME or ENUM?
I really hope you can help me to solve this as simple as possible, because I’m not a developer but I have some idea.
I use Dreamweaver CS5!
Cheers. Your Pilot