Database Help "Day of the week";

[Anon]

Hi,

I have a database, designed for a an airline, with a table called "flights".

In this I have:

|FlightNo |
|Departure |
|Destination |
|DepTime |
|ArvTime |
|Aircraft |

|Available |

I want to add a "Day Of The Week" function, so that the person who add's the flights can select what day of the week he wants the flight to be operated on.

Do you have any suggestions as to how I can do this?

Thanks
Ben

[sgbalsekar]

hi,

the following code is as of for 10th October 2001, u cud fetch the date,month and year from database..and use the code below and get the day of the year....

<?php
$ts=mktime(0,0,0,10,4,2001);
echo date('D',$ts);
?>

well if u dont manage to fetch date in the req format, just fetch the date and use explode function to get them in an array...

good luck,

sachin balsekar.