Hello,
Im not sure wheter this question should of gone under Mysql.

When i enter a date from my PHP page into mysql i have to use the format YYYY-MM-DD. Is there a setting to change this format as i would like to be able to enter DD-MM-YYYY

Thanks
Chris

No. MySQL date fields are a fixed format. You can manipulate the date info you get back from MySQL and display it however you want.

// We convert the MySQL date into a unix timestamp in the query:

$query = "SELECT UNIX_TIMESTAMP(date_column), ... AS date FROM table";
$result = mysql_query($query);

if (FALSE !== $result)
{
    while ($row = mysql_fetch_array($result))
    {
        // And format that unix timestamp into a DD-MM-YYYY string
        // for outputting.

        echo "Your date is " . date("d-m-Y", $row['date']) . ".\n";
    }
}

for more info, look at:
  http://www.mysql.com/doc/en/Date_and...functions.html
  http://www.php.net/date


Take care,

Nik
http://www.bigaction.org/