PhpMyAdmin help

[Decode]

Ive got a table and i need date and time for it, ive set the type to date but when i use
mysql_query("INSERT INTO datetime (date, time) VALUES('" . $date . "', '" . $time . "' )")

It puts the date as 0000-00-00 and the time as 00:00:00 instead of what i set it to.

ps. the $date var is $date = date("d/m/y")

[Protege]

Dont use table field types if you don't understand what they mean - use text/var chars/ints

[Decode]

Dont use table field types if you don't understand what they mean - use text/var chars/ints

I would use the default one, but i can't use "order" then because it will order them like this;

02-03-08
04-08-09
09-01-00
12-04-08
13-12-01

It treats the "-" like decimal points.

[Jackboy]

have the fields as varchar? U mayswell...

[Decode]

have the fields as varchar? U mayswell...

Read post #3. Its for a PM list so they need to be ordered by date, and having them as varchar won't work for that.

[Jackboy]

ohhhhhhhhhhhhhhhhhhhhhh

[Tomm]

Insure date is in the following format: YYYY-DD-MM and time is: HH:MM:SS and is a valid time/date.

[Trinity]

Read post #3. Its for a PM list so they need to be ordered by date, and having them as varchar won't work for that.

Couldn't you order them by an id field or something?

[Decode]

Insure date is in the following format: YYYY-DD-MM and time is: HH:MM:SS and is a valid time/date.

Thanks +rep.

Couldn't you order them by an id field or something?

If i did that then i would have the same problem as using varchar?