Value for menu

Alidad

hi, I'm trying to create update forms for member, i use dreamweaver cs3, when i created update forms with menu and click submit button, for some reason i got error said that "value cannot be nul"l for the b_month (birthday value)

please see codes in the bold and see what did i did wrong and how to fix that thanks.

<tr valign="baseline">
                <td nowrap align="right">Country:</td>
                <td><input type="text" name="country" value="<?php echo $row_Member_Recorder['country']; ?>" size="32"></td>
              </tr>
              <tr valign="baseline">
                <td nowrap align="right">City:</td>
                <td><input type="text" name="city" value="<?php echo $row_Member_Recorder['city']; ?>" size="32"></td>
              </tr>
              <tr valign="baseline">
                <td nowrap align="right">B_month:</td>
                [B]<td><lable name="b_month" value="<?php echo $row_Member_Recorder['b_month']; ?>" size="32"> <label>
  <select name="month" id="month">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
    <option value="7">7</option>
    <option value="8">8</option>
    <option value="9">9</option>
    <option value="10">10</option>
    <option value="11">11</option>
    <option value="12">12</option>
  </select>
  </label></td>[/B]              </tr>
              <tr valign="baseline">
                <td nowrap align="right">B_day:</td>
                <td><input type="text" name="b_day" value="<?php echo $row_Member_Recorder['b_day']; ?>" size="32"></td>
              </tr>

Kudose

The error is your database telling you that the b_month cannot be inserted with a NULL value.

Make sure that you are properly getting the data with $_POST['b_month'] and that you are populating it into your query, which you should post if you have further issues.

Alidad

hi, is used to be works fine with text field, but i changed that line to list/menu but is getting error message.

It has not thing to do with $POST['b_month'] because i have not change or touch anything in $POST['b_month'] line when it was works fine with text field before i changed to list/menu.

i noticed that i made mistake some line and i fix and still not working right please see code

          [CODE][B]<tr valign="baseline">
            <td nowrap align="right"><span class="style13"><strong>Month  </strong></span></td>
            <td><lable type="text" value="<?php echo $row_Member_Recorder['b_month']; ?>" size="32">
              <select id="month">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>

</select>
</td>
</tr>[/B][/CODE]

please help thanks.

Weedpacket

You've also misspelled "<label>" as "<lable>". Besides, a <label> element isn't a form field, it's supposed to refer to or contain a form field (an <input type="text">, in this case).

Alidad

where do you see misspelled "<label>" ! I also corrected some code but still not getting..
please see code to see if i missed anything!

<tr valign="baseline">
                <td nowrap align="right"><span class="style13"><strong>Month  </strong></span></td>
                <td><lable type="text" value="<?php echo $row_Member_Recorder['b_month']; ?>" size="32">
                  <label>
                  <select name="b-month" id="b-month">
                    <option value="1">1</option>
                    <option value="2">2</option>
                    <option value="3">3</option>
                    <option value="4">4</option>
                    <option value="5">5</option>
                    <option value="6">6</option>
                    <option value="7">7</option>
                    <option value="8">8</option>
                    <option value="9">9</option>
                    <option value="10">10</option>
                    <option value="11">11</option>
                    <option value="12">12</option>
                  </select>
                  </label></td>

Kudose

You're first label is lable

You need to have your select's name as b_month