<p><br />
<b><?php
echo $LangUI->_('Reviews');
?>
</b>:<br />
<?php
$sql = "SELECT review_user, review_comments, review_date, user_name FROM {$db_table_reviews}\n\t\tLEFT JOIN {$db_table_users} ON user_id = review_user WHERE review_recipe=? ORDER BY review_date";
$stmt = $DB_LINK->Prepare($sql);
$rc = $DB_LINK->Execute($stmt, array($recipe_id));
// Error check
DBUtils::checkResult($rc, NULL, NULL, $sql);
echo '<br /><br />';
if ($rc->RecordCount() == 0) {
echo $LangUI->_('This recipe has not been reviewed');
} else {
echo '<table cellspacing="1" cellpadding="5" border="0" class="ing" width="80%">';
while (!$rc->EOF) {
$dateTime = DBUtils::formatTimeStamp($rc->fields['review_date']);
echo "<tr><th align=left>" . $rc->fields['user_name'] . ', ';
echo "";
echo $dateTime[2] + 0 . "/" . ($dateTime[3] + 0) . "/" . $dateTime[1] . " ";
echo $dateTime[4] % 12 . ":" . $dateTime[5] . ' ';
echo $dateTime[4] / 12 ? $LangUI->_('pm') : $LangUI->_('am');
echo "</th></tr><tr><td><p>" . $rc->fields['review_comments'] . '</td></tr>';
$rc->MoveNext();
}
echo '</table>';
}
?>
