Apart from anything, you need to supply an option value for each of those options, not just rely on the browser which will default to passing the option *text* back from the form, if you specify no value. So your option elements should read

<option value="1">January</option>

Notwithstanding that, RE below - you guys are all nuts, this is a ridiculous way to do it.
Let MySQL do the work, it has perfectly good functions to do this :

SELECT  DATE_FORMAT(date_field_name, '%c') AS intDate,
                DATE_FORMAT(date_field_name, '%M'') AS strMonth
FROM yadda etc etc

Then you use (assuming your're using $result = mysql_fetch_assoc() as your looped result variable name)

$selected_month = (integer) $_GET["Smonth"];

while ($result = mysql_fetch_assoc($link)) {
        if ($selected_month==$result['intDate']) {
                $optionlist.=' selected="selected"';
}       //      End while


Cheers, Neil

To: php-db@lists.php.net
Date: Wed, 14 Dec 2005 15:52:31 +0100
From: El Bekko <[EMAIL PROTECTED]>
Subject: Re: Date Formatting Question

Bomgardner, Mark A wrote:
I am trying to format the month portion of a date that I am trying to
pull from MySQL to be placed into a drop down menu to modify the date.
modify and it would be easier to do it in PHP
Any pointers would be appreciated.

Mark Bomgardner
Technology Specialist

make a function like this:

function datenum2str($date)
        $newdate = str_replace("01","Jan",$date);
        $newdate = str_replace("02","Feb",$date);
        $newdate = str_replace("03","Mar",$date);
        $newdate = str_replace("04","Apr",$date);
        $newdate = str_replace("05","May",$date);
        $newdate = str_replace("06","Jun",$date);
        $newdate = str_replace("07","Jul",$date);
        $newdate = str_replace("08","Aug",$date);
        $newdate = str_replace("09","Sep",$date);
        $newdate = str_replace("10","Oct",$date);
        $newdate = str_replace("11","Nov",$date);
        $newdate = str_replace("12","Dec",$date);

        return $newdate;

And then use this:

echo "<select name=Smonth>";
echo "<option selected value=\"$sDate[1]\">$newdate</option>";

Hope it helps,

El Bekko

CaptionKit http://www.captionkit.com : Production tools
for accessible subtitled internet media, transcripts
and searchable video. Supports Real Player, Quicktime
and Windows Media Player.

VideoChat with friends online, get Freshly Toasted every
day at http://www.fresh-toast.net : NetMeeting solutions
for a connected world.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to