Ok this is my attempt:
First Of all its the insert part into mysql table. I set the departuredate type to date.
the date comes from an xml file and is stored as dd-mm-yyyy.
My php script read the xml file data, stores in an array called $product and then insert it into the mysql table. This works without problem except for the date part. as we know its not compatible with mysql format. So I tried to convert it to mysql format before it is inserted into the mysql table. At the moment, the conversion doesnt seem to work as the date column shows 0nly 0s. This is an extract of my PHP script:
$product = array() //name of the array where the file is stored
$name = $xmlReader->name;
if ($name == "product"
$product[$name] = $xmlReader->readString
$date1 = date('Y-m-d', strtotime($product["departuredate"]) ); // convert the departuredatae into mysql format
$result = mysql_query(
"INSERT INTO tablename SET "
departurepoint='" . escape($product["departurepoint"]) . "', "
destination='" . escape($product["destination"]) . "', "
departureDate='" . escape($product["date1"]) . "', "
Note the script works except for the departure bit