Displaying DATE from database?

[gc40]

I have a database field called `DATE` which has data type date.

The purpose of `DATE` as you guessed is to store a date. 2007-11-31

 

I want to write a script to update a news article posting date. The only way to do this is to break DATE into three separate sections, $year, $month and $day

 

How do I go about doing this?

 

Please keep in mind, the date is already stored in the database, it does not need to be today's date. It can be any date!

Lets work with 2007-11-31 as an example.

[Dane]

$dateformat = strtotime("$daterow");

 

date("Y", $dateformat); // for year

date("m", $dateformat); // for month

date("d", $dateformat); // for day

 

is how i did it.

[gc40]

How would I declare YEAR as a variable with your example?

 

$year = date("Y", $dateformat);

 

???

[Dane]

like that i believe

[gc40]

Not working!!

 

I think there is something wrong...

 

How do I link the field `DATE` to your code?

 

It ins't right.

[Dane]

You need to Select it from the database.

 

$daterow = $row['date_field'];