home *** CD-ROM | disk | FTP | other *** search
/ Chip 2004 April / CMCD0404.ISO / Software / Freeware / Programare / dotproject / modules / departments / vw_contacts.php < prev   
Encoding:
PHP Script  |  2003-12-17  |  1.0 KB  |  26 lines
  1. <?php
  2.     global $dept_id;
  3. ?>
  4.  
  5. <table border="0" cellpadding="2" cellspacing="1" width="100%" class="tbl">
  6. <?php
  7.     echo "<tr><th>".$AppUI->_("Name")."</th><th>".$AppUI->_("Email")."</th><th>".$AppUI->_("Telephone")."</th></tr>";
  8.     
  9.     $contact_department = db_loadResult("select dept_name
  10.                                          from departments
  11.                                          where dept_id='$dept_id'");
  12.     
  13.     $sql = "select contact_id, contact_first_name, contact_last_name, contact_email, contact_phone
  14.             from contacts
  15.             where contact_department='$contact_department'
  16.                   and (contact_owner = '$AppUI->user_id' or contact_private = '0')
  17.             order by contact_first_name";
  18.     $contacts = db_loadHashList($sql, "contact_id");
  19.     
  20.     foreach($contacts as $contact_id => $contact_data){
  21.         echo "<tr><td>".$contact_data["contact_first_name"]." ".$contact_data["contact_last_name"]."</td>";
  22.         echo "<td>".$contact_data["contact_email"]."</td>";
  23.         echo "<td>".$contact_data["contact_phone"]."</td></tr>";
  24.     }
  25. ?>
  26. </table>