Pb with the date.. please help

[monasa]

In the code bellow, when I show $dated I get 10-11-2004 but
When display $monthdeb, I get 2 !!


$dated = $row["dateD"];
echo $dated; //10-11-2004
//recuperer $datedeb de la base de donnée

$monthdeb = $datedeb["mon"];
echo $monthdeb //2

Please help

 

[sleipnir214]

Insufficient data for a meaningfun answer.

What is $datedeb['mon']? What is in that array?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[monasa]

I m sorry, the code is "

$dated = $row["dateD"]; //get a date from database
echo $dated; //10-11-2004

$monthdeb = $dated["mon"];
echo $monthdeb //I get 2!!

Thanks in advance

 

[sleipnir214]

The question still stands.

$dated will be one element from $row, specifically $row['dateD']. If $row is a row from a database it will be a singleton, not an array. Yet you are trying to reference an element of this singleton.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[monasa]

The probleme which I have is :
I have a date field in the mysql database, and I want to get the month from this field with php.

for example if the date in the database is 10-11-2004, I want to have 11 as the month

thanks.

 

[sleipnir214]

You can't just try to reference a month element. You're dealing with a string, not some kind of object.

You have several options. One is to use substr() to typographically pull out what you need. Another is to have Mysql separate out the date parts using its builtin date_format() function. A third would be to use PHP's strtotime() and getdate() functions to split the date up into parts.


Want the best answers? Ask the best questions!

TANSTAAFL!!