how do i get the form to eneter date and time

[homer09001]

ok i got a VA (Virtual Airline) that uses a php form etc that allows pilots to enter informtion about flights its works but what i want to know is how i make it so when the user hits submit it adds the date and time that the data in the form was submitted? to the database

ive moded the table to include the fields DATE & TIME but on the date its set default to 0000:00:00 how do i change it so that its enters the date DD:MM:YYYY

i also have 2 fields on the form Take Off Time and Landing Time is there any way to get php to work out the aunt of time in minutes it is between the 2 times and put that into the database e.g

if a pilot entered in the Take off box 12:00 in 24 hour format and in the land box he put 15:00 is there any way php could enter the amount of time it took which would be 180 minutes into the database

[thorpe]

check out the [man]datetime[/man] functions in the manual.

[homer09001]

thorpe wrote:

check out the [man]datetime[/man] functions in the manual.

BTW i have a very limited knowledge of php & MYSQL

[intenz]

Something like...?

<?php
$time1 = '12';
$time2 = '15';

$total = ( $time2 - $time1 ) * 60;
echo $total;
?>

[homer09001]

intenz wrote:

Something like...?

<?php
$time1 = '12';
$time2 = '15';

$total = ( $time2 - $time1 ) * 60;
echo $total;
?>

when they submit the form the time they took of and landed wil be in 24h format so i need it to take that time and work out how many minutes have elapsed betweent he 2 times