I can see where the php code to grab the info should be higher on the page - below the order search function before the display of the orders... correct? That would split the code in two spots.
1. php code to grab the info (but exactly where ???
PHP Code:
<?php
//--Add comments starts--
$orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($oID) . "'
order by date_added limit 1");
//--Add comments ends--
?>
2. The display of the comment in the table on screen
PHP Code:
<td class="dataTableContent" align="left"> echo ($orders_history->fields['comments'] == '' ? TEXT_NONE : nl2br(zen_db_output($orders_history->fields['comments']))) ?> </td>
Is this getting closer?
Bookmarks