Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Add address_book fields to query in osCommerce

Posted on 2008-10-31
1
278 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
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.

840 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