MYSQL Default Date

[Vini]

Ive created a data capture form, which people fill in. One field has the date attribute in mysql, hwoever it has defaulted to yyyy-mm-dd

How can I alter this? I want the user to select the date from a drop down D M Y, how can I make a D M Y drop down, so they can choose the date from a predetermined selection? and then how can I make it out put in DD/MM/YYYY format?

[Moby-Dick]

what code is the front end in ? PHP ?

[Vini]

what code is the front end in ? PHP ?

oops, aye.

[Moby-Dick]

any use ?
http://www.weberdev.com/get_example-4177.html

[Vini]

Its good, but christ knows (maybe he doesnt) how to get that into a form, and submit to the db. To me it looks like it has 3 variables $day, $month and $year, does my db need these three tableS??

[Moby-Dick]

pass - I was trying to think like a dev and its hurt my head already

I was wondering of there was some little date dropdown control you can use.

[Moby-Dick]

tips I got from my more dev orientated collegue.

- steal some java script from t'internet
- have 3 dropdown boxes , and concatenate the result into the data for SQL

http://www.mattkruse.com/javascript/calendarpopup/

[Vini]

as what im doing is basic of the basic, ill just have 3 variables, dmy and 3 boxes. cba with the effort of anything else.

cheers though, did that pipex thing ever come through? theyre showing me as 3 months free, 2 for migrating and 1 from ref... however, theyve billed me for migration and royally cocked up, yet they still havent sorted it almost a month down the line.