"); // exit(); //} if (isset($_REQUEST["show_all"]) && $_REQUEST["show_all"] == 1) { $my_adj = ""; $show_all = " checked"; } else { $my_adj = " LIMIT 25"; $show_all = ""; } $query = "SELECT * FROM tbl_raid INNER JOIN tbl_instance on tbl_raid.instance_id = tbl_instance.id WHERE tbl_instance.deleted = 0 AND tbl_raid.deleted = 0 ORDER BY raid_date DESC, tbl_raid.id DESC $my_adj"; $result = mysql_query($query); if ($result) {$number = mysql_numrows($result);} else {$number=0;} echo "

Raids

Show All

"; if ($number == 0){ echo ""; } else { $i = 0; $bgcolour = "#FFFFFF"; while ($i < $number){ $rec_id = mysql_result($result,$i,"id"); $rec_instance = stripslashes(mysql_result($result,$i,"instance_name")); $rec_raid_date = mysql_result($result,$i,"raid_date"); $rec_comment = mysql_result($result,$i,"comment"); if ($rec_raid_date !="" && $rec_raid_date != "0000-00-00 00:00:00"){ $dt_elements = explode(" " ,$rec_raid_date); $date_elements = explode("-" ,$dt_elements[ 0]); $rec_raid_date = $date_elements[2]."-".$date_elements[1]."-".$date_elements[0]; } else { $rec_raid_date = " "; } echo ""; if ($bgcolour == "#FFFFFF"){ $bgcolour = "#F5F5FF"; } else { $bgcolour = "#FFFFFF"; } $i++; } } echo "

Date	Instance	Comment
NO DATA
$rec_raid_date	$rec_instance	$rec_comment
$number Raids

"; include ("footer.php"); ?>