Could you guys help me out here?

[darthmahon]

Hey,

Ok I have a select form that selects information by using three drop down lists; month, day and year.

This is the code:

<td width="50%" class="Normal"> <form name="yearselect" action="meetings.php?type=date&data=$selectedate" method="POST">
                          <p>
                            <select name="day">
                              <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>
                            <select name="month">
                              <option value="01">1. Jan</option>
                              <option value="02">2. Feb</option>
                              <option value="03">3. Mar</option>
                              <option value="04">4. Apr</option>
                              <option value="05">5. May</option>
                              <option value="06">6. Jun</option>
                              <option value="07">7. Jul</option>
                              <option value="08">8. Aug</option>
                              <option value="09">9. Sep</option>
                              <option value="10">10. Oct</option>
                              <option value="11">11. Nov</option>
                              <option value="12">12. Dec</option>
                            </select>
                            <select name="year">
                              <option value="2004">04</option>
                              <option value="2005">05</option>
                            </select>
       <? $selectedate = $year . "-" . $month . "-" . $day; ?>
                            <input type="hidden" name="selectedate"  value="<? echo $selectedate; ?>">
                            <input type="submit" name="Submit2" value="Go">
                          </p>
                        </form></td>

I want the $selectedate variable to be passed to meetings.php but instead all I get is "$selectedate", not the actual date I selected from my drop down.

This is the SQL SELECT code in meetings.php

$meeting = "SELECT * FROM MEETINGS WHERE $type='$data'";

Any idea why this information isn't being passed properly?

Cheers,
Chris

[osusano]

why dont u just put this

<? $selectedate = $year . "-" . $month . "-" . $day; ?>

to your meeting.php i dont get the reason why u have to put it inside your form.

if u still insist well better do the assigning via javascript to pass the value of the selected form to another hidden variable

[swr]

I see a bunch of problems here.

First off, try using a more specific subject line when posting to forums, it may get you help sooner.

In your form tag, don't put variables in the action URL. Use hidden fields instead, like you did further below.

In your form tag's action URL, $selectdate is just that. You need to use <?php echo $selectdate ?> instead in order to get PHP to process $selectdate. Again, you did it correctly further below.

This won't work because it's in the wrong place:
<? $selectedate = $year . "-" . $month . "-" . $day; ?>
The snippet of code you've posted is what generates the form. When the form is being generated, $year $month and $day will not be set, because the user hasn't had a chance to specify them. You need to put that code in meetings.php, because that is where the form (with the date) will be submitted to.

Finally, don't use $year $month and $day. It may work, but could stop working if you upgrade PHP or change hosting providers. Use $_POST['year'] instead. Read the [man]register_globals[/man] manual page for more info.

[darthmahon]

Cheers guys.

Took on board what you mentioned, works now 🙂

Ta very much!