Jesus help me dynamic update in drop down

shankar · 05-08-2009, 07:22 PM

<form action="stud_attendance_report_month.php" name="select_date" method="POST">
View results of    
<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");
}
?>
<option value ="<?php echo $set_month_value;?>"><?php echo $set_month; ?></option>
<?php
}
?>
</select>
   

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

Am unable to get the output, it does not display any month name.
Can anybody help me, have to submit the project by evening.

allworknoplay · 05-08-2009, 07:32 PM

You can't do it that way, you are trying to output the resource with that approach. You have to do it like this:

Current:

PHP Code:


			
$set_month = mysql_query("SELECT MONTHNAME('".$thing."') FROM stud_attendance");

$set_month_value = mysql_query("SELECT MONTH('".$thing."') FROM stud_attendance");

New:

PHP Code:


			
$set_month = mysql_query("SELECT MONTHNAME('".$thing."') FROM stud_attendance");

$month_name_rows = mysql_fetch_assoc($set_month);

$month_name = $month_name_rows['MONTHNAME'];

$set_month_value = mysql_query("SELECT MONTH('".$thing."') FROM stud_attendance");

$month_value_rows = mysql_fetch_assoc($set_month_value);

$month_value = $month_value_rows['MONTH'];

ETbyrne · 05-08-2009, 08:11 PM

Sorry, couldn't help myself.

allworknoplay · 05-08-2009, 08:12 PM

haha, yeah he seems pretty frustrated. That should lighten him up.

But programming can do that to ya!