get date from mysql separately

[keikei]

I have records with type DATE (YYYY-MM-DD format) in my mysql database, but how can I get those records and separate them by year month and day so that I could put them on separate (input type=text) textboxes in my php code?? I know how to display the entire date in a single textbox but I do not how to call them separately. Can someone help me with this? 🙂

[rachel2004]

<?php
$today = "2004-06-13";

$sql = "SELECT UNIX_TIMESTAMP(my_date_column)
        FROM my_table
        WHERE my_date_column = '$today'";

$result = mysql_query($sql, $db_connection);

$row = mysql_fetch_array($result);

$month = date('F', $row['UNIX_TIMESTAMP(my_date_column)']);
$date  = date('j', $row['UNIX_TIMESTAMP(my_date_column)']);
$year  = date('Y', $row['UNIX_TIMESTAMP(my_date_column)']);

echo "In the U.S., today is: ".$month." ".$date.", ".$year;
?>

Look at the PHP manual to see other formatting arguments that you can give to the date() function.

[nemonoman]

$query="
SELECT DATE_FORMAT(myDate, '%Y') as myYear,
DATE_FORMAT(myDate, '%m') as myMonth,
DATE_FORMAT(myDate, '%d') as myDay
FROM myTable
";

$result=mysql_query($query);

$row=mysql_fetch_array($result);
$myYear=$row['myYear'];
$myMonth=$row['myMonth'];
$myDay=$row['myDay'];

echo "
<input type=text name=myyear value=$myYear>
<input type=text name=myMonth value=$myMonth>
<input type=text name=myDay value=$myDay>
";