Don't worry brother i have created a code for you in PHP which you need to use along with your HTML coding and there is no need to two select option.Following are the code for the same.
HTML Code:
<SELECT NAME="course_ID">
<OPTION VALUE="100">English</OPTION>
<OPTION VALUE="101">Hindi</OPTION>
<OPTION VALUE="102">Marathi</OPTION>
</SELECT>
PHP Code:
if ($course_ID =='100')
{
$Course_Name = 'English';
//code for the insert statement
}
if ($course_ID =='101')
{
$Course_Name = 'Hindi';
//code for the insert statement
}
if ($course_ID =='102')
{
$Course_Name = 'Marathi';
//code for the insert statement
}
Bookmarks