Still having problems...

bellaso

I am trying to add a date to a mysql database from a form. However I do not want to limit the user to entering the date as follows (YYYYMMDD). I would like the user to be able to enter the date in as (MM-DD-YYYY). If anyone can help me with this that would be great.

Thanks in advance for your help and time!!!

maniac1aw

make 3 different inputs

example

enter your date MM/DD/YYYY
<input type=text name=month>/
<input type=text name=day>/
<input type=text name=year>

then when you post the data all you have to do is this

$mydate="$year-$month-$day";

its ready now to be inserted into the database....

bellaso

The only reason this won't work is because I have a list that shows all my entries and it has to be sorted by date descending. So if I have the month, day, year separate it will not be able to perform this function.

thanks.

maniac1aw

if your date is MM-DD-YYYY when you get it (you would have to do error checking)


$month=substr($date,0,2);
$day=substr($date,3,2);
$year=substr($date,6,4);

echo "$year-$month-$day";

///convert it back to MM-DD-YYYY form
$yearr=substr($str,0,4);
$month=substr($str,5,2);
$day=substr($str,8,2);

echo "$month-$day-$year";