<form action="stud_attendance_report_month.php" name="select_date" method="POST">

View results of &nbsp;&nbsp;&nbsp;

<select name = "month" >

<?php

include("connect.php");

$query = mysql_query("SELECT * FROM stud_attendance WHERE username = 'srikant'");
$numrows = mysql_num_rows($query);

if ($numrows!=0) {
	$row = mysql_fetch_assoc($query);
	$id = $row['stud_id'];
	$thing = $row['date'];
	$set_month = mysql_query("SELECT MONTHNAME('".$thing."') FROM stud_attendance");
	$set_month_value = mysql_query("SELECT MONTH('".$thing."') FROM stud_attendance");
	
	for ($i=0;$i<=10;$i++) {
	
	?>
		<option value ="<?php echo $set_month_value;?>"><?php echo $set_month; ?></option>
<?php
	}
} ?>

</select>

&nbsp;&nbsp;&nbsp;

<input id='button' type='submit' name='select_date' value='Submit' />
</form>