PhpMyAdmin help

http://www.tehupload.com/images/app-...4859376235.png

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")

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

Quote:

---

Originally Posted by Protege

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.

have the fields as varchar? U mayswell...

Quote:

---

Originally Posted by Jackboy

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.

ohhhhhhhhhhhhhhhhhhhhhh

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

Quote:

---

Originally Posted by Tom743

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?

Quote:

---

Originally Posted by Tomm

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

---

Thanks :) +rep.

Quote:

---

Originally Posted by Trinity

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?