Solved

Add address_book fields to query in osCommerce

Posted on 2008-10-31
1
276 Views
Last Modified: 2013-12-13
I'm a total newbie to sql and my developer is not available. I need urgently to add certain fields of the address_book table to the code below, so I can export this information including the mailing address:

The fields we have in the address book table that I need here are:

entry_street_address
entry_suburb
entry_postcode
entry_city
entry_state

Can someone help please?
----------------------------------------------------------------------------------
 
require('includes/application_top.php');
 
tep_db_query("truncate table customers_marketing");
 
$customers_query = tep_db_query("select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, i.customers_info_date_account_created, i.customers_info_source_id from " . TABLE_CUSTOMERS . " c left join customers_info i on (i.customers_info_id = c.customers_id) order by i.customers_info_date_account_created desc, c.customers_lastname, c.customers_firstname");
 
while ($customers = tep_db_fetch_array($customers_query)) {
 
$orders_query = tep_db_query("select date_purchased from " . TABLE_ORDERS . " where customers_id = '" . (int)$customers['customers_id'] . "' and orders_status <> '4'");
$orders_result = tep_db_fetch_array($orders_query);
 
$entry_referral = tep_get_sources_name($customers['customers_info_source_id'], $customers['customers_id']);
$entry_referral2 = tep_get_sources_name2($customers['customers_id']);
 
 
//table values
$customers_id = $customers['customers_id'];
$customers_firstname = $customers['customers_firstname'];
$customers_lastname = $customers['customers_lastname'];
$customers_email_address = $customers['customers_email_address'];
 
$customers_info_date_account_created = tep_date_short($customers['customers_info_date_account_created']);
 
$source = $customers['customers_info_source_id'] == '9999' ? 'Other' : stripslashes($entry_referral);
$source_detail = stripslashes($entry_referral2);
 
$orders = tep_db_num_rows($orders_query);
 
$sql_data_array = array('customers_id' => $customers_id,
'customers_firstname' => $customers_firstname,
'customers_lastname' => $customers_lastname,
'customers_email_address' => $customers_email_address,
'customers_info_date_account_created' => $customers_info_date_account_created,
'source' => $source,
'source_detail' => $source_detail,
'orders' => $orders);
 
 
tep_db_perform('customers_marketing', $sql_data_array);
 
}
 
echo "customers_marketing database table filled - export to csv from phpmyadmin";
 
echo '<p><a href="java script:history.back();"><u>Back</u></a>';
?>
-----------------------------------------------------------------------------------------------------

Open in new window

0
Comment
Question by:poemorella
1 Comment
 

Accepted Solution

by:
poemorella earned 0 total points
ID: 22855025
Solved
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
How important is it to take extra precautions to protect your online business? These are some steps you can take to make sure you're free of any cyber crime.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question