Do yourself a favor and read the mysql manual.  It explicitly answers your
questions and many more you are likely to have.  Furthermore, there is a
searchable manual online at that makes it rather easy to find
answers about mysql.

To get you started, here is a link to a description of all of the column
types includeing date, varchar and char.

Good Luck

Trongduc <[EMAIL PROTECTED]> wrote in message
> hi there,
> I try to save a record (in the "date" type in MySQL) from the <INPUT
> type=text> by :
> $query = "INSERT INTO $table VALUES  ($post_id, 0, '$topic', '$uname',
> '$body', $date, '$newdate', 0) ";
> But it couldn't work (I used $date or '$date' on above, but they got the
> same results) !
> It showed me the wrong value, as : 1970-0-0 (always this, although I try
> input different values in the text box with the date format is YYYY-MM-DD)
> I don't understand the way MySQL saves my date field in his data (is it
> Can anyone help me in this case ?
> Thanks much...
> ps : I used the $date field in "varchar(20) type" instead. BWT, what's
> different beween the Varchar(length) type with the Char(length) type ?

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to