Solved

Add address_book fields to query in osCommerce

Posted on 2008-10-31
1
273 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
Comment Utility
Solved
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Often people are aiming at development of perfect Magento websites. Though, it is easier said than done. You know what’s much easier? To ruin everything. It can be done in seconds. Many of us experimented with design, tried to change some values dir…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now