"); // exit(); //} $raidid = $_REQUEST["id"]; $query = "SELECT * FROM tbl_raid INNER JOIN tbl_instance ON tbl_raid.instance_id = tbl_instance.id WHERE tbl_raid.id = $raidid"; $result = mysql_query($query); $number = mysql_numrows($result); if ($number!=0){ $form_raid_date = mysql_result($result,0,"raid_date"); $form_instance = mysql_result($result,0,"instance_name"); $form_comment = mysql_result($result,0,"comment"); if($form_raid_date !="" && $form_raid_date != "00-00-00 00:00:00"){ $date_time = explode(" " ,$form_raid_date); $date_elements = explode("-" ,$date_time[0]); $form_raid_date = $date_elements[2]."-".$date_elements[1]."-".$date_elements[0]; } else { $form_raid_date = ""; } } Else { echo(""); exit; } ?>

$rec_session ($rec_comment) $rec_attendance

"; $query2 = " SELECT * FROM tbl_attendees INNER JOIN tbl_member ON tbl_attendees.member_id = tbl_member.id WHERE raid_id = $raidid AND session_id = '$rec_session' ORDER BY status DESC,member_name"; $result2 = MYSQL_QUERY($query2); if($result2) {$number2 = MYSQL_NUMROWS($result2);} else {$number2 = 0;} if ($number2!=0){ $z=0; $y=0; $current_state = ""; while($z<$number2){ $rec_member = mysql_result($result2,$z,"member_name"); $rec_state = mysql_result($result2,$z,"status"); if ($current_state != $rec_state){ if ($current_state != ""){echo " ";} echo "$rec_state "; $current_state = $rec_state; $y=0; } echo "$rec_member  "; $z++; $y++; if ($y >= 15){ echo " "; $y=0; } } } echo "

"; $i++; } } include("footer.php"); ?>