06-08-2009, 03:16 PM
|
#2 (permalink)
|
|
The Contributor
Join Date: Nov 2008
Location: Norway
Posts: 58
Thanks: 20
|
I believe you have to use while() or something similar when dealing with more than one result (more than one month). Try this:
PHP Code:
<?php
$query2 = mysql_query("SELECT * FROM attendance WHERE Stud_ID = '1'");
$numrows2 = mysql_num_rows($query2);
while($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;
}
echo '<option value="' . $set_month_value . '">' . $month_name . '" - "' . $load_year . '</option>';
}
?>
|
|
|