Hi,
I have a problem inserting date into my database. In my database, I have a table called 'member' and one of the fields is 'graduationDate' which its datatype is 'timestamp' and 8 characters long (ex. 07152004). I have an html file that has a drop down list for month and day, and a text box for year. Here is how it looks:
<th scope="row"><div align="left" class="style45">Graduation Date: </div></th>
<td><div align="left"><span class="style45">
<select name="month">
<option>[Month]</option>
<option>January</option>
<option>February</option>
<option>March</option>
<option>April</option>
<option>May</option>
<option>June</option>
<option>July</option>
<option>August</option>
<option>September</option>
<option>October</option>
<option>November</option>
<option>December</option>
</select>
<select name="day">
<option>[Date]</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
<input type="text" name="year">
My question is, how do I insert the graduation date into my database? Is it possible to add it, if in my database, the graduation date is 8 fields long, while in my html file it is a drop down list. BTW, im using php as my scripting language.
