Custom Page

austinl · Post by **austinl** » Fri Feb 13, 2015 11:41 am

I am having issues with my custom page. Can someone please help me correct my code?

<?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
		assignments
		JOIN users ON users.ID = announcements.User";
		echo $dbhelper->ExecuteHtml($sql, array("fieldcaption" => TRUE, "tablename" =>
		array("users", "announcements")));
		?>
	</div>
</div>

mobhar · Post by **mobhar** » Fri Feb 13, 2015 11:51 am

So, what is your issue exactly?

austinl · Post by **austinl** » Fri Feb 13, 2015 11:52 am

It is not displaying any data in the panel.

mobhar · Post by **mobhar** » Fri Feb 13, 2015 12:02 pm

Make sure the SQL is valid and returns the result properly, by executing it first using your Database manager.

danielc · Post by **danielc** » Fri Feb 13, 2015 3:30 pm

austinl wrote:
FROM assignments JOIN users ON users.ID = announcements.User";

Double check if your table name is assignments or announcements.