HI, hope someone can help, I have just done my forst data base, now obviously the date in mysql is yyyy mm dd but when my users see it on the web interface I want them to see dd mm yy - how do I do this, have tried various sql commands and php but still displays incorrectly.

Thanks in advance

Ya man!!!

You can either format the date in your MySQL query or with PHP.

In MySQL, you'll need the DATE_FORMAT() function.
  http://www.mysql.com/doc/en/Date_and...functions.html

SELECT DATE_FORMAT(date_col, '%d %m %y')
  FROM table_name

You can do it in PHP using regular expressions. Take a look at preg_replace()
  http://www.php.net/preg_replace

Also, you can convert the MySQL date to a unix timestamp, and then convert that timestamp to a date format of your choosing. PHP's date() function is similar to MySQL's DATE_FORMAT().
  http://www.php.net/strtotime
  http://www.php.net/date

date('d m y', strtotime($mysql_date));



Take care,

Nik
http://www.bigaction.org/

:D:D

Many thanks Nik I will look at this today, have been wrestling with this for 2 days, appreciate your help.

G

Ya man!!!

Did it work?

Take care,

Nik
http://www.bigaction.org/

Not yet, still srugling with it I'm new to PHP so not sure wher to be putting the command, my data base is generated by a software programme, got the entry to be accepted but when it run it comes back with a 'function undefined errror'!!!


Ya man!!!