From MYSQL DB to Textbox Problem

[jrhitokiri]

usually, when i have questions regarding my DB systems, i just google, and i always find this forum very helpful, so i decided to join this forum and ask this question i coulndt find on the net, 'coz i think you guys know a lot about this:

I have this Datetime field in my mysql DB, which i queried with the SELECT command. now in my page, i have this input field for datetime. in this input box, i would like to place the value in my MYSQL DB as a default value, but when i tried to do this:

[PHP]
<input type="text" name="date_time" value =<? printf("%s",$date_time); ?> >
[/PHP]

it only outputs the date, and not include the time.
i tried to output what was in the variable before the input box and what i got was this:

2008-04-02 10:30:00

but in the box, it only showed

2008-04-02.

here's the select statement and php code i used at the top of the page.. what am i doing wrong?

SELECT DATE_FORMAT(date_time,'%Y-%m-%d %H:%i:%s'),
FROM project WHERE project.ctrl_no = '$proj_id'
 

[PHP]$date_time = $row[0];[/PHP]

[ronverdonk]

Since there are 'strange' characters in the value field, like a blank, you have to enclose the value in the input statement within quotes. Like this[php]<input type="text" name="date_time1" value ="<? printf("%s",$date_time); ?>" >

or

<input type="text" name="date_time2" value ="<? echo "$date_time;" ?>" >[/php]Ronald

[jrhitokiri]

Since there are 'strange' characters in the value field, like a blank, you have to enclose the value in the input statement within quotes. Like this[php]<input type="text" name="date_time1" value ="<? printf("%s",$date_time); ?>" >

or

<input type="text" name="date_time2" value ="<? echo "$date_time;" ?>" >[/php]Ronald

i see.. il try this one out.. ill come back here if i have some more problems. thanks!:D i really appreciate it.

[ronverdonk]

Glad I could assist. See you around.

Ronald