ZC Comment Storage

[lamajlooc]

Hi,
At the moment I'm using ZC in conjunction with UPS Worldship. It's working great except I want the comments set by the user (I changed the open input to a pre-defined drop-down) to be automatically entered into the "reference" section of a UPS shipping label.

So I put in a call to get the comment from the DB and instead of grabbing the comment, it keeps returning what I THINK is a null value. I've checked the database and ZC's admin area and they both show the comments but my query only ever returns "Resource id #15"...that's a null value right?

Anyway. I looked at the DB and the comments cell in zen_orders_status_history has randomly three, two, or one comment cell per order ID usually including an empty cell.

I can do a manual work-around but I'd really like it to be automated...for the XML script generated contains the comment...

[BlindSide]

Any customer comments will show up in the first order status record, all subsequent comments are added via the Zen Admin. So, sort the result in ascending order and limit the results to one, like so:

$db->Execute("select * from " . TABLE_ORDERS_STATUS_HISTORY . " 
              where orders_id = '" . $orders_id . "'
              order by orders_status_history_id asc limit 1");

Does that help?