ZC Inventory Report Module

[lat9]

Oh, I see now, it's a coding issue in the original script (I've got no idea how it ever ran properly). The 'and' clauses are being built up into an array and then want to be stringified for use in the SQL query.

The correct PHP function to use is implode, like this:

$db_category_where = " WHERE ".implode(" AND ", $where_array);

[tdkapdc]

Nice work,

Hit the nail right on the head, and is now working perfectly.

Thank you very much for your assistance.

It has made a useful tool in to an extremely useful tool for me.

Much appreciated.

Tim Bowden
TDK APDC

[lat9]

Tim, thanks for the follow-up; I'm glad to have helped.

... and ... welcome to the Zen Cart community!