====== Staff engaged for Lakshmi tender ======

FIXME - need to list new staff [[IFU>employees.php|IFU HR System]]

<php>
// set the necessary connection variables
include ("/var/www/html/IFU/sqlconnect.php"); 
// 20 connect to MySQL server and select the IFU database
include ("/var/www/html/IFU/sqlconnect2.php"); 

$db = mysql_select_db('full-moon_info_-_IFU',$connection);

$query = 'SELECT * FROM Employees where active="YES" ORDER by EmplID';
$result = mysql_query($query);

// 36 the first bit of the table that we want to do once
  echo "<table width=90% cellpadding=1>";
  echo "<tr>\n
	  <td><b>EmplID\n
	  <td><b>Name\n
	  <td><b>Skill\n
	  <td><b>Type\n
	  <td><b>Status\n
         </tr>\n";

// 46 a while loop to put all the data in a row at a time (pg 184)
  while ($employees=mysql_fetch_array($result,MYSQL_ASSOC))
  {
    extract($employees);
    echo "<tr> \n
	    <td>$EmplID</td> \n
	    <td>$FirstName $Surname</td> \n	
	    <td>$MainSkill</td> \n
	    <td>$EmplType</td> \n
	    <td>$Status</td> \n
	  </tr> \n";
   }
// 58 finally close off the html table
   echo "</table>\n";

</php>


[[:universe:IFU|back]]
[[http://www.theuniverse.org.uk/campaigns/ifu/index.htm|{{:universe:ifu-icon.jpg|See main IFU pages}}]]