For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > May 2006 > Re: [PHP-DB] Date Conversion









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [PHP-DB] Date Conversion
Brad Bonkoski

2006-05-16, 7:00 pm



Mark Bomgardner wrote:

> PHP 4.4/MySQL 4.0
>
> I am tying to convert a date to put into a database from a string (ie:
> January, February) to a numeric value (ie: 01,02). I am taking the
> value from a form, which is a drop down menu listing the months.
>
> $sMonth1 = $_POST['Smonth']; returns the money selected from the form.
> When I go to format the month from a string to numeric with
> date('m',strtotime($sMonth1));
> it returns 12, no matter which month I select.
>
> In reading the docs at php.net, date('m',strtotime($sMonth1)); is
> correct to reformat from a string to a time format.
>
> What am I missing.
>
>
> mark bomgardner
>

An idea along a different path would be....
for your original select box where you pick the month do something like
this:
<option value="01">January</option>
<option value="02">Febuary</option>
.....

Then the value passed to your form will be the numeric representation of
the month so there will be no need to translate the String --> number..

HTH
-Brad
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com