Hey all,

@nuin & @peterdd

Do you guys have a table prefix on your zen-cart installation?

@nuin try:

PHP Code:
SELECT count( zen_orders_id ) AS zilla FROM zen_orders WHERE customers_id = '1' 

@peterdd: do you also have table pre-fixes? - i can't see any in your example but i suspect that you may have?

Andy.