[Openfirst-cvscommit] projects viewmembers.php,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv21182

Added Files:
	viewmembers.php 
Log Message:
initial upload

--- NEW FILE: viewmembers.php ---
<?php
/*
 *  openFIRST.projects - meetings.php
 *
 * Copyright (C) 2003,
 *  openFIRST Project
 *  Original Author: David Di Biase <dav...@ea...>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA
 *
 */

  // Include globals and set header condense (not coded yet)
  include("../config/globals.php");
  $header_condense = true;
  include($header);
  if(! isset($user->user)){
    showlogin();
  } else {
  
  $group_query = mysql_query("SELECT * FROM ofirst_projects_groups");
  $group = mysql_fetch_object($group_query);

?>
<h2 align="center">Members for the <font color='red'><?php echo $group->GroupName; ?></font> Group</h2>
 <table width="299" align="center">
   <tr>
     <td class="sub" width="123">Username</td>
     <td class="sub" width="164">Full Name </td>
   </tr>
   <tr>
   <?php

    // View assigned members to related project
    $assigned = explode(",",$group->Members);
    foreach($assigned as $assign){

	  $member_query = mysql_query("SELECT * FROM ofirst_members WHERE user = '".$assign."'");
	  $member = mysql_fetch_object($member_query);
	  
      echo "<td>$assign</td>";
      echo "<td>".$member->firstname." ".$member->lastname."</td>";

    }

      ?>
   </tr>
 </table>
 <p>&nbsp;</p>
<?php
  } 
  include($footer);
?>