Unable to list all the month names and mont values
 

<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..

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