<form action="stud_attendance_report_month.php" name="select_date" method="POST">
View results of &nbsp;&nbsp;&nbsp;
<select name = "year" >
<option value = "0">Select one</option>
<?php
include("connect.php");

$query1 = mysql_query("SELECT * FROM attendance WHERE Stud_ID = '1'");
$numrows1 = mysql_num_rows($query1);
if ($numrows1!=0)
{
$row1 = mysql_fetch_assoc($query1);
$thing = $row1['att_date'];

$set_year_name = date("Y",strtotime(".$thing."));
$set_year_value = date("y",strtotime(".$thing."));

$set_year_prev_name = $set_year_name - 1;
$set_year_prev_value = $set_year_value - 1;


?>
<option value ="<?php echo $set_year_value;?>"><?php echo $set_year_prev_name." - ".$set_year_name; ?></option>
<?php
}
?>
</select>
&nbsp;&nbsp;&nbsp;
<select name = "month" >
<option value = "0">Select one</option>
<?php
$query2 = mysql_query("SELECT * FROM attendance WHERE Stud_ID = '1'");
$numrows2 = mysql_num_rows($query2);
if ($numrows2!=0)
{
$row2 = mysql_fetch_assoc($query2);
$thing = $row2['att_date'];

$get_rows = mysql_query("SELECT att_date FROM attendance");
$month_rows = mysql_query("SELECT MONTHNAME('".$thing."') FROM attendance");
$set_month_name = date("M",strtotime(".$thing."));
$set_month_value = date("m",strtotime(".$thing."));
$assis_count = mysql_num_rows($get_rows);
$month_count = mysql_num_rows($month_rows);



switch ($set_month_value)
{
case 01:$load_year = $set_year_name; break;
case 02:$load_year = $set_year_name; break;
case 03:$load_year = $set_year_name; break;
case 04:$load_year = $set_year_name; break;
case 05:$load_year = $set_year_name; break;
case 06:$load_year = $set_year_prev_name; break;
case 07:$load_year = $set_year_prev_name; break;
case 08:$load_year = $set_year_prev_name; break;
case 09:$load_year = $set_year_prev_name; break;
case 10:$load_year = $set_year_prev_name; break;
case 11:$load_year = $set_year_prev_name; break;
case 12:$load_year = $set_year_prev_name; break;
}

?>
<option value ="<?php echo $set_month_value;?>"><?php echo $month_name." - ".$load_year; ?></option>
<?php
}
?>
</select>
&nbsp;&nbsp;&nbsp;
<input id='button' type='submit' name='select_date' value='Submit' />
</form>
</center><hr>

There are 3 month names added in the table of attendance, but in the dropdown there is only May that is displayed but not the actual names that are available in the database, help me..

__________________
--
Regards
Shankar

I believe you have to use while() or something similar when dealing with more than one result (more than one month). Try this: