MySQL date problem

[DaveTomneyUK]

Hi,

I am trying to make a page with PHP + MySQL but I have run into a small problem. When I create my tables in MySQL I put as below but it keeps putting the date as 0000-00-00. How do I make it so it makes the date UK based EG - "DD/MM/YYYY" instead of US based EG - "MM/DD/YYYY".

`date` date default NULL

Thanks

[Drakla]

you have to use DATE_FORMAT when sucking the date out - just do a search on the mysql site

[DaveTomneyUK]

Sorted cheers