<?php
session_start();

$group = $_GET['group'];

/*
$dbHost = "mysql.scms.waikato.ac.nz";
$dbUser = "jk159";
$dbPass = "10171640";
$dbDatabase = "jk159";
*/


$dbHost = "localhost";
$dbUser = "root";
$dbPass = "";
$dbDatabase = "jk159";


$db = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("Error connecting to database.");

mysql_select_db("$dbDatabase", $db) or die ("Couldn't select the database.");

/*
if($group=="all")
 {
	$result=mysql_query("select * from contacts", $db);
 }
 else
 {
	$result=mysql_query(" select * from contacts WHERE group ='colleagues' ", $db);
 }
 */

 $result=mysql_query("select * from contacts where test_id='$test_id'", $db);

while ($row = mysql_fetch_assoc($result)) {

$id = $row['id'];
$fn = $row['firstName'];
$ln = $row['lastName'];
$em = $row['email'];

$grouplist = "<table width=\"700\" border=\"1\"><tr>
    <td width=\"150\">".$fn."</td>
    <td width=\"150\">".$ln."</td>
    <td width=\"400\">".$em."</td>
  </tr>
</table>";

$table = ($grouplist.$table);

}

$_SESSION['table'] = $table;
header( "Location: index.php" );

mysql.close();

?>