how to divide whole date into part

[austine_power007]

I want to retrieve date from access and i think its in mm/dd/yy format so how can i divide each of the separately i want part by part dd then mm then yy then i will show in 3 different text field.......i think someone is ready to ans me :)

[fert]

[code]
$date=explode("-",$date);
echo "<input type=\"text\" name=\"name\" value=\"{$date[0]}\"><input type=\"text\" name=\"name\" value=\"{$date[1]}\"><input type=\"text\" name=\"name\" value=\"{$date[2]}\">";
[/code]

[alpine]

[quote author=fert link=topic=118037.msg482002#msg482002 date=1165730764]
[code]
$date=explode("-",$date);
[/code]
[/quote]

Exept that the correct one in this case is explode("/",$date);

You can also look into substr()

[fert]

well if it's not stored as a DATE in a mysql database.

[alpine]

:) That's true fert - i just try to base the solution on what was presented by the topic starter, hence the quote.

[austine_power007]

Well i mentioned ACCESS mean i am using Microsoft Access 2003 database is this code works with that ??

[alpine]

explode() is a php function and will handle whatever you have fetched from your db