PHP - How Can I Keep Values Of This Type Drop Down List Has It Has 3 Selects For Date

Hi i have a drop down menu for date which is meant to insert all 3 values into a date column bt is only sending the year how can i fix it

<select name="date_of_birth">

    <option value="1">January

    <option value="2">February

    <option value="3">March

    <option value="4">April

    <option value="5">May

    <option value="6">June

    <option value="7">July

    <option value="8">August

    <option value="9">September

    <option value="10">October

    <option value="11">November

    <option value="12">December

</select>

<select name="date_of_birth">

    <option value="1">1

    <option value="2">2

    <option value="3">3

    <option value="4">4

    <option value="5">5

    <option value="6">6

    <option value="7">7

    <option value="8">8

    <option value="9">9

    <option value="10">10

    <option value="11">11

    <option value="12">12

    <option value="13">13

    <option value="14">14

    <option value="15">15

    <option value="16">16

    <option value="17">17

    <option value="18">18

    <option value="19">19

    <option value="20">20

    <option value="21">21

    <option value="22">22

    <option value="23">23

    <option value="24">24

    <option value="25">25

    <option value="26">26

    <option value="27">27

    <option value="28">28

    <option value="29">29

    <option value="30">30

    <option value="31">31

</select>

<select name="date_of_birth" id="year">

<?php

$year = date("Y");

for($i=$year;$i>$year-50;$i--)

{

if($year == $i)

echo "<option value='$i' selected>Current Year</option>";

else

echo "<option value='$i'>$i</option>";

}

?>

Hi,
In my mysql database i have a text input option, in the registration form and edit my details form i have a multiple select dropdown list, which user selects options to populate the text input box, which ultimately populates the text field in the mysql database.
All works perfectly.

The dropdownlist consists of 3 parts <optgroups> first is current selection (what is the usesr current selection)works fine, The second <optgroup> is existing words, what words we(the site) have given as options, and the third <optgroup> is the words that others have used. This is where im having a small problem.
Because its a text field when i call the data from the database, it calls the entire text box as a single option in my select list..

I want to break the words in the text field (at the comma) and have them listed each one as an option in the select list.


Example what i need:

Words in text box:(my input allows the "comma")
word1, word2, word3, word4, word5, word6,

How i want them called/displayed:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

here's my code:
$query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $original_functionsexperience =doSelectSql($query,1);
         $query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $functionsexperiencelist=doSelectSql($query);
          $funcexpList ="<select multiple=\"multiple\" onchange=\"setFunctionsexperience(this.options)\">";   
         foreach ($functionsexperiencelist as $functionsexperienceal)
            {
            $selected="";
            if ($functionsexperienceals->allwords == $original_functionsexperience)
               $selected=' selected="selected"';
            $allwords=$functionsexperienceal->allwords;
            $funcexpList .= "<optgroup label=\"Current selection\">
            <option value=\"".$allwords."\" ".$selected." >".$allwords."</option>
            </optgroup>      
              <optgroup label=\"Existing Words\">
              <option value=\"existing1,\">existing1</option>
              <option value=\"existing2,\">existing2</option>
              <option value=\"existing3,\">existing3</option>
              <option value=\"existing4,\">existing4</option>
              <option value=\"existing5,\">existing5</option>
              <option value=\"existing6,\">existing6</option>
         </optgroup>
         <optgroup label=\"Others added\">    //heres problem
         <option value=\"".$allwordsgeneral."\">".$allwordsgeneral."</option>
         </optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         
      
         
   The result im getting for optgroup others added:
   word1, word2, word3, word4, word5,

how can i get it like this:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

Ok basic setup is

Table name = unit_data
I have a field  unit_paid_date colum type = DATE

unit_paid_date = 2011-03-02
thats yyyy-mm-dd

lets say for example the DueDate is the Second of every month

I need to select all records from unit_data that are PAST DUE
so if the last paid date is 2011-01-02

that record will pop up as PAST DUE

BUT if that paid date is say 2011-03-10 it will not be shown because the invoice was paid Ahead of due date

I had this almost working properly -- but can use any help you guys offer.
I was attempting to use mysql WHERE queries and do checks against paid_date but failed

Thanks

I have a dropdown list which have some elements.
I want to get all the elements of the dropdown list into a variable of type array.

Any Idea???