new customer or repeat customer

Hi
When in orders->edit order
I would like to display under the ip address the number of orders from this customer. When I print this page it will allow us to add promotional material to the order depending on whether this is the first or additional order from this customer.

I am trying to alter /admin/orders.php to achieve this.

I have found in /admin.customers.php a query to calculate the number of orders from a customer based on the customers id.

The steps I believe I need are

1. In /admin/orders.php I need to identify the customers id in the "edit order" display from the order id
2. Create a query similar to the query in customers.php
3. Display the information.

Steps 2 & 3 I think I can work out once I have the customers id.

I am stuck on step 1. Can someone point me in the direction to calculate the customers id from the order id.

My php & mysql skills are basic, so be gentle.

gilby

You could do a quick search for existing orders by adding to the file:
/admin/orders.php

around line 348 just before the closing ?> the following:

      $zc_customers_query = $db->Execute("select customers_id from " . TABLE_ORDERS . " WHERE orders_id = '" . $oID . "'");
      $zc_count_orders_query = $db->Execute("select count(*) as count_orders from " . TABLE_ORDERS . " WHERE customers_id = '" . $zc_customers_query->fields['customers_id'] . "'");

Now you can echo the results for:
$zc_count_orders_query->fields['count_orders']

where you like on the orders page ...

This is actually a little faster to obtain the count:

      $zc_count_orders_query = $db->Execute("select count(*) as count_orders from " . TABLE_ORDERS . " WHERE customers_id = '" . $order->customer['id'] . "'");

So you do not need both lines ...