Dropdown with radio button

BuzzStPoint

I'm working / Modifying code I have found for a dropdown.

What I'm trying to achieve.
I would like 2 radio buttons, One that says Swimming pool, one that says Whirlpool. But only one can be selected. Then a dropdown with the months of the year.

If Swimming Pool is selected, then October in the drop down. I would like to post to the database s10. If Whirlpool was selected, then w10

So far I have a dropdown and it posts to the database. How would I change this to do what I wanted?

<?php
include("connect.php");   

if (!isset($_POST['submit']))
{
    echo '
    <form action="" method="POST">
    Month:
    <select name="month">
    <option value="1">January
    <option value="2">February
    <option value="3">March
    <option value="4">April
    <option value="5">May
    <option value="6">June
    <option value="7">July
    <option value="8">August
    <option value="9">September
    <option value="10">October
    <option value="11">November
    <option value="12">December   

    </select> <input type="submit" name="submit" value="Load">
    </form>
    ';
}
else
{
    if ($_POST['month'] == 1)
    {
        echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected January<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        // place code here for option #1
            $update = mysql_query("UPDATE Pool_Config SET Selected_Month='1' WHERE Monthid='1'")
            or die(mysql_error());  

    }

if ($_POST['month'] == 2)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected February<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='2' WHERE Monthid='1'")
        or die(mysql_error());  
}

if ($_POST['month'] == 3)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected March<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='3' WHERE Monthid='1'")
        or die(mysql_error());  
}
if ($_POST['month'] == 4)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected April<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='4' WHERE Monthid='1'")
        or die(mysql_error());  
}
if ($_POST['month'] == 5)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected May<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='5' WHERE Monthid='1'")
        or die(mysql_error());  
}
if ($_POST['month'] == 6)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected June<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='6' WHERE Monthid='1'")
        or die(mysql_error());  
}
if ($_POST['month'] == 7)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected July<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='7' WHERE Monthid='1'")
        or die(mysql_error());  
}
if ($_POST['month'] == 8)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected August<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';    
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='8' WHERE Monthid='1'")
        or die(mysql_error());  
}
if ($_POST['month'] == 9)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected September<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='9' WHERE Monthid='1'")
        or die(mysql_error());  
}
if ($_POST['month'] == 10)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected October<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='10' WHERE Monthid='1'")
        or die(mysql_error());  
}             
if ($_POST['month'] == 11)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected November<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='11' WHERE Monthid='1'")
        or die(mysql_error());  
}
if ($_POST['month'] == 12)
{
    echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected December<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
        $update = mysql_query("UPDATE Pool_Config SET Selected_Month='12' WHERE Monthid='1'")
        or die(mysql_error());  
} 
}
?>

big_nerd

I hope this is what you wanted:

<?php
include("connect.php");   

if (!isset($_POST['submit']))
{
    echo '
    <form action="" method="POST">
    <input type="radio" name="type" value="s">Swimming Pool</input> <input type="radio" name="type" value="w">Whirlpool</input> <br />
    Month:
    <select name="month">
    <option value="1">January</option>
    <option value="2">February</option>
    <option value="3">March</option>
    <option value="4">April</option>
    <option value="5">May</option>
    <option value="6">June</option>
    <option value="7">July</option>
    <option value="8">August</option>
    <option value="9">September</option>
    <option value="10">October</option>
    <option value="11">November</option>
    <option value="12">December</option>   

    </select> <input type="submit" name="submit" value="Load">
    </form>
    ';
}
else
{

$month = (int)$_POST['month']; // Grab the current Month
$monthName = date("F",mktime(0, 0, 0, $month, 1, date('Y'))); // Grab the current Month Name    
$type = $_POST['type'];

if (($type == "s" || $type == "w") && ($month >= 1 && $month <= 12)) {
  $insertData = $type.$month; // for instance, w10
  echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected '.$monthName.'<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
  $update = mysql_query("UPDATE Pool_Config SET Selected_Month='".$insertData."' WHERE Monthid='".$month."'")
  or die(mysql_error());    


} else {
  die("Invalid Data Posted!");
} // end if
}
?>

I had helped you out with a couple of items.

1) The month MUST be a number, between 1 and 12 (a little more secure)
2) Followed HTML standards by closing </option> (more complient)
3) Added radio Buttons
4) Adjusted the query so that instead of adding '12' to Month '12' I added 'w12' to month '12' (for whirlpool for instance)
5) You didn't ask for it, but I shortened your code, you don't need the 12 IF statements, I can help you to reinstate them if you like, but what i gave you does the same thing, this done done by using the date() function to grab the month name.

Example SQL Query for Whirlpool October:

// Output: You selected October
UPDATE Pool_Config SET Selected_Month='w10' WHERE Monthid='10'

I hope this helps.

BuzzStPoint

You've helped me greatly..

I ended up changing a bit of the code.. It really helped me a lot..
But I do have one more thing to ask.. Is there a way to have another table updated depending on if the swimming pool or whirlpool was selected?

have all the code work the way it does now. BUt if someone selects Swimming pool radio button, Update a different table with a 1. And if Whirlpool is selected it will update that same table?

Here's is my code as it stands now.

<?php
include("connect.php");   

if (!isset($_POST['submit']))
{
    echo '
    <form action="" method="POST">
    <input type="radio" name="type" value="Pool">Swimming Pool</input> <input type="radio" name="type" value="Whirl">Whirlpool</input>
    <select name="month">
    <option value="January_">January</option>
    <option value="February_">February</option>
    <option value="March_">March</option>
    <option value="April_">April</option>
    <option value="May_">May</option>
    <option value="June_">June</option>
    <option value="July_">July</option>
    <option value="August_">August</option>
    <option value="September"_>September</option>
    <option value="October_">October</option>
    <option value="November_">November</option>
    <option value="December_">December</option>   

    </select> <input type="submit" name="submit" value="Load">
    <a href="" onclick="printpage();">Print page</a>
    </form>
    ';
}
else
{
    $month = $_POST['month']; // Grab the current Month
//    $monthName = date("F",mktime(0, 0, 0, $month, 1, date('Y'))); // Grab the current Month Name    

    $type = $_POST['type'];

if (($type == "Pool" || $type == "Whirl")) {
  $insertData = $month.$type; // for instance, w10
  echo '<head><meta http-equiv="refresh" content="2; URL=index.php"></head>You selected '.$month.'<br />Reloading in 2 seconds or click here: <a href="index.php">Main Page</a>';
  $update = mysql_query("UPDATE Pool_Config SET Selected_Month='".$insertData."' WHERE Monthid='1'")
  or die(mysql_error());    


} else {
  die("Invalid Data Posted!");
} // end if
}
?>

This works great.. If someone selects Whirlpool and January. the table is updated to: January_Whirl
I like that...

But now for another part of the site I need a selection added.
Basically, if Someone selects Swimming Pool & March,
Selected_Month is updated to: March_Pool
Selected_Pool is updated to 1 (If Swimming Pool is selected, enter 1, if Whirlpool is selected enter 2)

Is there a way to make both updates?