Add wednesdays to MySQL

[ooda55]

Hi there

im working on a reservation system for a weekly club

i have everything finished but the system requires the admin to add the date (eg. 09/12/2009) of every wednesday to a mysql table so that a drop down menu of wednesdays can be created on teh reservations page

i have seen those little dropdown javascript callenders before

but can someone please tell me if it is possible to make one that only displays wednesdays?

 

thanks alot

chris

[ooda55]

it will need to be in UK date format (DD/MM/YYYY)

just to avoid confusion

 

thanks again

chris

[phant0m]

this will output the next 10 Wednesdays:

<?php
    for($i = 0; $i < 10; $i++){
        echo strftime("%d/%m/%Y",strtotime("next wednesday +$i week"))."<br />";
   }
?>

I hope it'll help

[ooda55]

Thanks thats a good start, but how can i put these into a dropdown menu, like in a form

<option>datesgohere</option>

is as far as i got

[phant0m]

just use your intuition

<?php
    for($i = 0; $i < 10; $i++){
        echo '<option>'.strftime("%d/%m/%Y",strtotime("next wednesday +$i week")).'</option>';
   }
?>

[ooda55]

ahh cheers mate 

[phant0m]

you're welcome