populating a dropdown menu from a database

[fogofogo]

Hello all,

I am trying to populate a drop down menu with a mysql database. I was hoping to have a selection of months in the dropdown menu, based on date fields in my database (displayed like january, february, march, april, ,may etc)

when a user then selects a month, they will be brought to a new page that will have only the records created in that month.

But in my database, the date is stored in this format: 2006-05-12 00:00:00

Is there any way that I could replace the dates with the months?

for example : 2006 - 05, would be May 2006.

if you need to see my code, here it is:

<? 

//database connection

$query = mysql_query("SELECT * FROM casinocredit"); 

// start to print out the form

echo "<form action=\"cats.php\" method=\"POST\"><select name=\"clients\"><option value=\"\" \"selected\">Select A Client</option>";

// loop through the records

while ($row = mysql_fetch_array($query))

{

echo "<option value=\"{$row['ID']}\">{$row['ddate']}</option>";
}
echo "</select>";

echo "<input type=\"submit\" value=\"Go\"></form>";
?>

Anyone have any advice or opinions?

Thanks for your time

J

[abou.hmed]

you need to use the following function
date('M-Y'),strtotime($row['ddate']))
this function will display the date in the wanted format
reply for more information

[BuezaWebDev]

Change your query to

$query = "SELECT ID, DATE_FORMAT(ddate, '%b %Y') FROM casinocredit"; 

The output should be your dropdown with dates formatted like this: Jan 2005, Feb 2005, etc.