Need help parsing dates for mysql format

benatdot

I need some help in setting up this form for an interface to a database. I have three drop down boxes next to one another. These are for a date, one for the month, one for the day, one for the year. I did the interface this way because I wanted to restrict the user to control input. I'm ok on adding or changing a date from the values in these three drop down boxes into the mysql database using this method. The part I need help on is once I receive the date from a query. I would get something like, 2001-11-22. I don't know php well enough to parse that out into three variales, each for the year, month day, so I can put those values in the html form controls when the webpage loads, thus the user see's the date as part of the data they queried. So, in closing, how do I parse things in php, seperating a big variable, into smaller ones. Thanks for the help, hope I was clear on what I'm trying to accomplish.

ben

ereptur

list($year,$month,$day) = split("-",$date_from_db);

DeltaRho2K

You can use the ereg function as well.

<?php
if (ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $date, $regs)) {
    echo "$regs[2]-$regs[3]-$regs[1]";
} else {
    echo "Invalid date format: $date";
}
?>

Change the $date to the name of the variable queried from the DB. The $regs is the variable you are assigning to the ereg array, so you don't need to do anything with that.

This returns the date in the format of mm-dd-yyyy
Just change around the $regs numbers to fit your needs. In other words, 3,2,1 returns date in dd-mm-yyyy.

Bunkermaster

SELECT
    DATE_FORMAT( yourdatefield , '%m %e %Y' ) as myDate
from
    mytable

SQL does it perfectly...