concact 3 from fields values into one

vinny199

Hi,

This may sound strange way of doing it, but i'm desperate to find a solution to this problem.

I'm dealing with a database where the user selects a date using 3 fields:

$year
$month
$day

Then on form submit, the values are inserted into the database.

My problem is that when i want to display records using a date filter, this can't be done at this stage because i do not have a field in the database that stores a proper date in a computerised format such as 20050303 for 2005 03 03

What i would like to do is to add a database row "$DATE"

on my form, when the user has selected the 3 values $year $month $day I would like to have a hidden field "DATE" that retrieves these 3 values and make them one.

then on insert into the database i would have a real computerdate stored as well as the 3 separate fields.

I have no idea how to do this, get that hidden field to pick up the values entered by the user and make them one.

I'm not very good with php, if you can help and reply, could you please give practical example to demonstrate?

Many thanks,

Vinny

jayant

you dont need a hidden field

you can do the following in php

<?php

$dt=sprintf("[%04s]",  $year).sprintf("[%02s]",  $month).sprintf("[%02s]",  $day);

?>

$dt has the formatted date

vinny199

thanks,

but if it $dt doesnt get "stored" into a form field of some sort, then i can't insert it itinto the databse when the form is submitted and the rest of the form fields values are inserted into the database, can i?

Many thanks for your help

vinny199

I'm not sure I'm explaining what i'm stuck with very well.

I've tried the code you posted.

What i get inserted in the database is: [0000][00][00] for the value $dt that i have added to a hidden field to insert into the database.

My code is as follow

(part of the form)

                      <td width="29"><strong>Year</strong></td>
                      <td width="74"><select name="year" id="year">
                          <option value="SELECT">SELECT</option>
                          <option value="2005">2005</option>
                          <option value="2006">2006</option>
                          <option value="2007">2007</option>
                        </select></td>
                      <td width="43"><strong>Month</strong></td>
                      <td width="2">&nbsp;</td>
                      <td colspan="2"> <select name="month" id="month">
                          <option value="SELECT">SELECT</option>
                          <option value="01">January</option>
                          <option value="02">February</option>
                          <option value="03">March</option>
                          <option value="04">April</option>
                          <option value="05">May</option>
                          <option value="06">June</option>
                          <option value="07">July</option>
                          <option value="08">August</option>
                          <option value="09">September</option>
                          <option value="10">October</option>
                          <option value="11">November</option>
                          <option value="12">December</option>
                        </select></td>
                      <td width="27"><strong>Day</strong></td>
                      <td width="147"><select name="day" id="day">
                          <option value="SELECT">SELECT</option>
                          <option value="01">01</option>
                          <option value="02">02</option>
                          <option value="03">03</option>
                          <option value="04">04</option>
                          <option value="05">05</option>
                          <option value="06">06</option>
                          <option value="07">07</option>
                          <option value="08">08</option>
                          <option value="09">09</option>
                          <option value="10">10</option>
                          <option value="11">11</option>
                          <option value="12">12</option>
                          <option value="13">13</option>
                          <option value="14">14</option>
                          <option value="15">15</option>
                          <option value="16">16</option>
                          <option value="17">17</option>
                          <option value="18">18</option>
                          <option value="19">19</option>
                          <option value="20">20</option>
                          <option value="21">21</option>
                          <option value="22">22</option>
                          <option value="23">23</option>
                          <option value="24">24</option>
                          <option value="25">25</option>
                          <option value="26">26</option>
                          <option value="27">27</option>
                          <option value="28">28</option>
                          <option value="29">29</option>
                          <option value="30">30</option>
                          <option value="31">31</option>
                        </select></td>
                    </tr>
                    <tr> 
					<?php

$dt=sprintf("[%04s]", $year).sprintf("[%02s]", $month).sprintf("[%02s]", $day);

?>
<td colspan="5"><input name="a" type="hidden" id="a" value="<?php echo $dt ?> " /></td>

What I'm trying to do, is get $dt to pick up the selected values that the user selected for the menu option fields of $year,$month,$day

get these 3 values "joined together" as $dt that will then get posted into the database as one single date like 20050303

At the moment $dt is not picking up the selected values for year, month and date, but produces a series of [0000]

Can you point me in the right direction?

Thanks,

Vinny