<?php 

// $sql = "SELECT * from tblKiosksKingsway inner join tblProvince on tblKiosksKingsway.intProvince = tblProvince.intProvince";
$sql = "SELECT * from tblKingswayKindness2015";
$result = getFromDatabase($sql);
if (mysqli_num_rows($result) == 0)
{
	$content = "<p>Sorry no entries found</p>";
}
else
{
	while ($row = mysqli_fetch_array($result) )
	{
		$c_first_name = $row['strFirstName'];
		$c_last_name = $row['strLastName'];
		$c_email = $row['strEmailAddress'];
		$c_phone = $row['strPhone'];
		// $c_address = $row['strAddress'];
		// $c_city = $row['strCity'];
		// $c_province = $row['strProvince'];
		// $c_postal = $row['strPostal'];
		$c_date = $row['entryDate'];
		// $c_gender = $row['strGender'];
		// $c_optIn = $row['ynOptIn'];
		
		$content .= '<tr>
			<td>'.$c_first_name.'</td>
			<td>'.$c_last_name.'</td>
			<td>'.$c_email.'</td>
			<td>'.$c_phone.'</td>

			<td>'.$c_date.'</td>
		
			</tr>';

			// $content .= '<tr>
			// <td>'.$c_first_name.'</td>
			// <td>'.$c_last_name.'</td>
			// <td>'.$c_email.'</td>
			// <td>'.$c_phone.'</td>
			// <td>'.$c_address.'</td>
			// <td>'.$c_city.'</td>
			// <td>'.$c_province.'</td>
			// <td>'.$c_postal.'</td>
			// <td>'.$c_date.'</td>
			// <td>'.$c_gender.'</td>
			// <td>'.$c_optIn.'</td>
			// </tr>';
	}
}

?>