====== Staff engaged for Lakshmi tender ====== FIXME - need to list new staff [[IFU>employees.php|IFU HR System]] // 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 ""; echo "\n \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 " \n \n \n \n \n \n \n"; } // 58 finally close off the html table echo "
EmplID\n Name\n Skill\n Type\n Status\n
$EmplID$FirstName $Surname$MainSkill$EmplType$Status
\n";
[[:universe:IFU|back]] [[http://www.theuniverse.org.uk/campaigns/ifu/index.htm|{{:universe:ifu-icon.jpg|See main IFU pages}}]]