Hi need help with dropdown menu

[desiinusa123]

Hi I am newbie here...I am new to php. i HAVE A QUESTION REG THIS DROP DOWN, which is in .html and while action takes place it takes me to process1.php

 

.HTML CODE

students:

    <label>

    <select name="students" size="1" id="students">

        <option value="Freshman">FreshMan</option>

        <option value="Sophomore">Sophomorer</option>

        <option value="Junior">Junior</option>

        <option value="Seniorr">Senior</option>

    </select>

    </label>

how can I implement php code to select ONLY one of those items....

I need u r guidance or any reference

THnaks in adv

 

[ngreenwood6]

in your process1.php file you will have something like this:

 

<?php

//this selects what is selected in the dropdown box
$students = $_POST['students'];

?>

 

Hope this helps.

[desiinusa123]

but i have to enter the student into DB. for example in the dropdown the user chooses One freshman/sophomore/.....and that shoudl be inserted into DB. that is the deal...could u pls help me.\thanks

 

[jej1216]

If you are using MySQL, you would do something like this to insert data:

<?php

$db = mysql_connect("myhost", "blahlogin", "blahpw");

if (!$db)
   {
   die('Could not connect:'.mysql_error);
   }

mysql_select_db("dbname",$db);

$sql = "INSERT INTO tableA (fieldA, fieldB, fieldC)
VALUES ('$_REQUEST[fieldA]',
'$_REQUEST[fieldB]',
'$_REQUEST[fieldC]')";

if (!mysql_query($sql,$db))
    {
    die('Error: '.mysql_error());
    }
mysql_close($db);

?>

 

Does that help?