home *** CD-ROM | disk | FTP | other *** search
/ Chip 2004 April / CMCD0404.ISO / Software / Freeware / Programare / dotproject / modules / admin / vw_usr_proj.php < prev    next >
Encoding:
PHP Script  |  2003-02-19  |  736 b   |  31 lines
  1. <?php /* ADMIN $Id: vw_usr_proj.php,v 1.3 2003/02/19 02:13:44 eddieajau Exp $ */
  2. GLOBAL $AppUI, $user_id;
  3.  
  4. $sql = "
  5. SELECT projects.*
  6. FROM projects
  7. WHERE project_owner = $user_id
  8.     AND project_active <> 0
  9. ORDER BY project_name
  10. ";
  11. $projects = db_loadList( $sql );
  12.  
  13. $pstatus = dPgetSysVal( 'ProjectStatus' );
  14. ?>
  15. <table width="100%" border=0 cellpadding="2" cellspacing="1" class="tbl">
  16. <tr>
  17.     <th><?php echo $AppUI->_('Name');?></th>
  18.     <th><?php echo $AppUI->_('Status');?></th>
  19. </tr>
  20.  
  21. <?php foreach ($projects as $row) {    ?>
  22. <tr>
  23.     <td>
  24.         <a href="?m=projects&a=view&project_id=<?php echo $row["project_id"];?>">
  25.             <?php echo $row["project_name"];?>
  26.         </a>
  27.     <td><?php echo $pstatus[$row["project_status"]]; ?></td>
  28. </tr>
  29. <?php } ?>
  30. </table>
  31.