Admin Notes Advanced

[sbbemn]

To make this super_invoice.php appearance a bit refined I see where the note itself would be better to keep visible in admin only, but the title could appear on the invoice.

<td class="dataTableContent"><?php echo $notes->fields['notes_title']; ?></td>

I need to draw the info from the notes table and link to the customer ID to show on that customer's invoice though.

Is this close as it does not currently work? Also, how do I specify the Order Notes category only (notes_categories_id)?

<?php
    $table_notes = $db->Execute("select notes_title
from " . TABLE_NOTES . "
where customers_id = '" . $order->customer['id'] . "'");  
?>