getdate() function ???

[tsabar]

hi, i can't get the hang of these date functions and when i can use them and when i can't.

i'm pulling date variables out of my mysql database in the following format:
2005-11-30 12:08:55

trying to check if the month is equal to January (for instance):

$tdate = getdate($row['mydate']);
if ($tdate['month'] == "January") {
// execute code
}

something is wrong i think with the following line:
$tdate = getdate($row['mydate']);

how do i convert the data i pull from the database (2005-11-30 12:08:55) into a php date variable that i can check parts of it? (month, day, year)

thanx!
o

[rincewind456]

Look at MySQL Date and Time Functions you can recall the data any way you want.

[tsabar]

i used the following and it worked:

$t = strtotime ($row[mydate]);
$DateArray = getdate($t);
$Month = $DateArray[month];
$Day = $DateArray[mday];
$Year = $DateArray[year];