Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Customer info


MoisesZaragoza

Recommended Posts

If you are going to do this on a regular basis, I'll suggest you create a php file for it. Unfortunately, this means you'll need to know how to write PHP codes.

 

If you are doing it just occasionally, then using phpMyAdmin is a good way. Simply select your database from the pulldown menu on the left column, then click on SQL tab at the top. In the run SQL query/queries box, paste the following codes and click on Go button:

 

select concat(c.customers_lastname,', ',c.customers_firstname) as full_name, a.entry_street_address, a.entry_city, a.entry_state, c.customers_telephone, c.customers_email_address from customers c, address_book a, customers_info ci where c.customers_id = a.customers_id and c.customers_id = ci.customers_info_id order by ci.customers_info_date_account_created

 

I hope this is what you're looking for... :blush:

Link to comment
Share on other sites

<?php 1

2 require('includes/application_top.php');

3 require(DIR_WS_CLASSES . 'currencies.php');

4 $currencies = new currencies();

5 $orders_statuses = array();

6 $orders_status_array = array();

7

8

9

10

11 $orders_query = tep_db_query(select concat(c.customers_lastname,', ',c.customers_firstname) as full_name, a.entry_street_address, a.entry_city, a.entry_state, c.customers_telephone, c.customers_email_address from customers c, address_book a, customers_info ci where c.customers_id = a.customers_id and c.customers_id = ci.customers_info_id order by ci.customers_info_date_account_created);

12 $row_orders_query = mysql_fetch_assoc($orders_query);

13 $totalRows_orders_query = mysql_num_rows($orders_query);

14 $order_exists = true;

15

16

17

 

 

 

?>

at the end of the day the code will be good

Link to comment
Share on other sites

Check your syntax. Query should be enclosed with double quotes.

 

In your case, it should be:

 

$orders_query = tep_db_query("select concat(c.customers_lastname,', ',c.customers_firstname) as full_name, a.entry_street_address, a.entry_city, a.entry_state, c.customers_telephone, c.customers_email_address from customers c, address_book a, customers_info ci where c.customers_id = a.customers_id and c.customers_id = ci.customers_info_id order by ci.customers_info_date_account_created");

 

And since you are using a php file and not a direct SQL query from phpMyadmin, you may change the above line to the following if you wish to follow the osCommerce standard:

 

$orders_query = tep_db_query("select concat(c.customers_lastname,', ',c.customers_firstname) as full_name, a.entry_street_address, a.entry_city, a.entry_state, c.customers_telephone, c.customers_email_address from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " a, " . TABLE_CUSTOMERS_INFO . " ci where c.customers_id = a.customers_id and c.customers_id = ci.customers_info_id order by ci.customers_info_date_account_created");

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...