<?php

// Database Connect
$db_host = 'localhost'; //hostname
$db_user = 'username'; // username
$db_password = 'password'; // password
$db_name = 'database'; //database name

$link = mysql_connect($db_host, $db_user, $db_password) or die("ERROR: Cannot connect to database.");
@mysql_select_db($db_name);
mysql_query("SET NAMES utf8") or die("err: " . mysql_error());



$classquery = mysql_query("SELECT * FROM `DATABASE`.`TABLE` WHERE COLNAME ='".$class."' ORDER BY COLNAME DESC LIMIT 20");

	if(mysql_num_rows($member) == 0 ) {
		// Echo no results.
		echo '<p>No Results were found.</p>';
	// Results
	} else {
		while($che = mysql_fetch_array($classquery)) {

			// Store Member Details
			$memberid = $che['MemberID'];
			$date = $che['Date'];
			$timein = $che['TimeIn'];
			$timeout = $che['TimeOut'];

			// Echo table contents
			echo '
			<tr>
			<td>'.$member.'</td>
			<td>'.$date.'</td>
			<td>'.$timein.'</td>
			<td>'.$timeout.'</td>
			</tr>';
		// End While
		}
	}

<?php