Code: Select all
sql ="SELECT a.entry_postcode, a.customers_id, f.store_postcode, f.store_email
FROM address_book a
INNER JOIN franchises f
ON a.entry_postcode = f.store_postcode
WHERE a.customers_id = '$customerid'"Now i just need to figure out the code on how to get my $customerid variable out of this array (code posted below)...
Code: Select all
$this->customer = array('id' => $order['customers_id'],
'name' => $order['customers_name'],
'company' => $order['customers_company'],
'street_address' => $order['customers_street_address'],
'suburb' => $order['customers_suburb'],
'city' => $order['customers_city'],
'postcode' => $order['customers_postcode'],
'state' => $order['customers_state'],
'country' => $order['customers_country'],
'format_id' => $order['customers_address_format_id'],
'telephone' => $order['customers_telephone'],
'email_address' => $order['customers_email_address']);$customerid = $order['customers_id']
Thanks for all you help!