Dashboard Issues

[austinl]

I am having some issues making my dashboard. None of the data I am trying to display is showing up. The html side looks fine, but I am not sure about the php.

<div class="container-fluid">
<?php
$dbhelper = new cems_db();
?>
<div class="panel panel-primary">
<div class="panel-heading text-center">
<h2>Announcements</h2>
</div>

	<div class="panel-body">
		<?php
		$sql = "SELECT
		users.first_name AS User,
		announcements.Subject AS Subject,
		announcements.Message AS Message,
		FROM
		announcements
		INNER JOIN users ON users.first_name = announcements.User";
		echo $dbhelper->ExecuteHtml($sql, array("fieldcaption" => TRUE, "tablename" =>
		array("users", "announcements")));
		?>
	</div>
</div>

	<div class="row">
		<div class="col-md-6">
			<div class="panel panel-info">
			<div class="panel-heading text-center">
				<h2>Members</h2>
			</div>
			<div class="panel-body">
				<?php
				$sql = "SELECT
				members.CAPID AS CAPID,
				members.first_name AS First Name,
				members.last_name AS Last Name,
				FROM
				members";
				echo $dbhelper->ExecuteHtml($sql, array("fieldcaption" => TRUE, "tablename" =>
				array("members")));
				?>
			</div>
		</div>
	</div>

		<div class="col-md-6">
			<div class="panel panel-info">
			<div class="panel-heading text-center">
				<h2>Signed In</h2>
			</div>
			<div class="panel-body">

			</div>
		</div>
	</div>
</div>

<div class="row">
	<div class="col-md-12">
		<div class="panel-warning">
			<div class="panel-heading text-center">
				<h2>Assets</h2>
			</div>
			<div class="panel-body">
				<ul class="nav nav-pills nav-justified">
					<li><a data-toggle="tab" href="#">Radios</a></li>
					<li><a data-toggle="tab" href="#">Equipment</a></li>
					<li><a data-toggle="tab" href="#">Locations</a></li>
				</ul>
			</div>
		</div>
	</div>
</div>

</div>

[mobhar]

1. Make sure your SQL can be run properly using your Database Manager.
2. Make sure you have already has class "cems_db" in the generated "emsdb.php" file.
3. If you are using MySQL database, make sure the connection info is valid in the "emsdb.php" file.