Hi Raymond,

in this case you could use MetaMod to simply display HTML via the PHP code in the module. Normally MetaMod uses its PHP code to determine whether or not to show a different module, but it's fine for this purpose too.

Here's some very basic PHP to place into the PHP box in MetaMod. You may wish to change the way the HTML code is output, and that's up to you.

$query = "select * from xyz_new_table where ID = 2";
$db->setQuery($query);
$result = $db->loadObject();
if ($result) {
  echo '<table><tr>';
  echo '<td>' . $result->some_info . '</td>';
  echo '<td>' . $result->a_number . '</td>';
  echo '<td>' . $result->an_other_number . '</td>';
  echo '</tr></table>';
}


In order to embed this in an article, you could use the {loadposition} operator and plugin to load the MetaMod into the article.

Best regards,
Stephen